SUMPRODUCT

[Dhardy]

I need to calculate the total ($) collected between 8/17 & 8/24 if the value
of the cooresponding data in column N is "1". Here is the formual so far (for
the data collection between the specific dates)
=SUMPRODUCT(--([Book1]Sheet1!A5:A1000>=DATEVALUE("8/17/2009")),--([Book1]Sheet1!A5:A1000<=DATEVALUE("8/24/2009")).
How do I modify the formula to only total the collections if N is "1"?

 

[bapeltzer]

Besides the criteria for column N, you also don't have the $ range you want
to total. In the formula below, I've assumed it's in column B, but you can
adjust as needed:

=SUMPRODUCT(--([Book1]Sheet1!A5:A1000>=DATEVALUE("8/17/2009")),--([Book1]Sheet1!A5:A1000<=DATEVALUE("8/24/2009")),--([Book1]Sheet1!N5:N1000=1),[Book1]Sheet1!B5:B1000)