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)