# Thread: Sum for multiple Conditions; EXCEL 2003

1. ## Sum for multiple Conditions; EXCEL 2003

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

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

Thanks

3. ## Sum for multiple Conditions; EXCEL 2003

Solution to be on Metrics tab, cel L4
Solution should be: 119 (The sum of 33 cells)
Criteria = (DateReceived>=\$A4)*(DateReceived<=\$B4 )*(Validationor="April Whitfield") -->yes, 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

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

Steve

5. ## The Following User Says Thank You to sdckapr For This Useful Post:

musical1 (2011-05-03)

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

Merci,
Jody

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•