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

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

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

Hi,

Where C1 & C2 contain the lower and upper date range

=SUMPRODUCT((A1:A1441=C1)*(A1:A1441<=C2)*(B1:B144 1))

Mike

"SRacak" wrote:

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