Prev: Condional Formatting with Percents
Next: How do I get the MSNStockQuote function in Excel?
From: Mike H on 9 Feb 2010 10:57
Try this

=SUMPRODUCT((D2:D3565="0 Paper")*(F2:F3565=1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"MadProphet" wrote:

> I am trying to get a count of how many rows have a value of "1" in the F
> column AND have a value of "0 PAPER" in the D column. I keep getting an error.
>
> I am using Excel 2003 and the following formula
> =SUMIF('CURRENT EDIT STATUS'!D2:D3565,"0 PAPER", 'CURRENT EDIT
> STATUS'!F2:F3565)
From: Mike H on 9 Feb 2010 11:02
oops,

your referring to another worksheet

=SUMPRODUCT(('CURRENT EDIT STATUS'!D2:D3565="0 Paper")*('CURRENT EDIT
STATUS'!F2:F3565=1))


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mike H" wrote:

> Try this
>
> =SUMPRODUCT((D2:D3565="0 Paper")*(F2:F3565=1))
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "MadProphet" wrote:
>
> > I am trying to get a count of how many rows have a value of "1" in the F
> > column AND have a value of "0 PAPER" in the D column. I keep getting an error.
> >
> > I am using Excel 2003 and the following formula
> > =SUMIF('CURRENT EDIT STATUS'!D2:D3565,"0 PAPER", 'CURRENT EDIT
> > STATUS'!F2:F3565)
 | 
Pages: 1
Prev: Condional Formatting with Percents
Next: How do I get the MSNStockQuote function in Excel?