ExcelBanter - SUMPRODUCT

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUMPRODUCT (https://www.excelbanter.com/excel-discussion-misc-queries/240696-sumproduct.html)

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"?

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)

"Dhardy" wrote:

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"?