How do I create a "SUMIF" based upon a Date Range?

S

SRacak

Column A represents the "Date" of an occurence.
Column B represents the "Cost" of each occurance.

There are 1,441 rows.

I want to know what the Cost is for a specific date range, the month of
December 2007 (i.e. =>12/01/2007 and <=12/31/2007).

Any suggestion will be appreciated.


~SRacak
 
M

Mike H

Hi,

Where C1 & C2 contain the lower and upper date range

=SUMPRODUCT((A1:A1441>=C1)*(A1:A1441<=C2)*(B1:B1441))

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with Sum in between dates 12
VLOOKUP or SUMIF for Multiple Criteria 2
very complex IF function if not an alternative function of crossselection 0
counting the occurrence of specific text within a date range 4
Lookup and count all cells that fall between 2 dates 3
YTD SUMIF based on current date 3
Count Dates in a range based on Column Header Id without using sum-product 1
Counting multiple occcurrences between date range 3

Top