Sum for multiple Conditions; EXCEL 2003

Topic

New Reply

I used this formula to return the number of times that “Monika” appeared for a given date range.

=SUMPRODUCT((DateReceived>=$A4)*(DateReceived<=$B4)*(Validationor="Monika"))
A4 contains my minimum date and B4 contains my upper date range.

Now, I want to ADD (sum) the numbers in range AN3:AN5000 for the above criteria.
FYI, the name of range AN3:AN5000 is NumReports

-Jody

Reply | Quote

Replies

Hi Jody – If possible, please attach a sample spreadsheet.

Thanks

Reply | Quote

Attached is my spreadsheet.

Solution to be on Metrics tab, cel L4
Solution should be: 119 (The sum of 33 cells)
Criteria = (DateReceived>=$A4)*(DateReceivedyes, I changed the name from above, I wasn’t planning on posting the spreadsheet and thought it easier if the name used in the example wasn’t the name of a month

Add named range “NumReports” (Ad Hoc Reports tab, AN3:AN5000)

BTW: I know that I am attaching a 2007 file, but it WILL be in a 2003 spreadsheet. I am posting from home where I have 2007

-Jody

Reply | Quote

=SUMPRODUCT((DateReceived>=$A4)*(DateReceived<=$B4 )*(Validationor="April Whitfield")*NumReports)

Steve

Reply | Quote

Thank you! I had danced around so many similar attempts, but I was trying to make it more difficult than it was.

Merci,
Jody

Reply | Quote