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

How can I define date range criteria in SUMIF formula? 1
Sumif Multiple Columns 2
how to get the random date between the start date and the end date? 3
Calculating Salary based on Date Range 2
Finding a date range from given date 1
Possible getpivotdata with offset? 1
Countif Function for dates in a range 2
Date range lookup....tough one! 19

Top