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

  • Thread starter Thread starter SRacak
  • Start date Start date
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
 
Hi,

Where C1 & C2 contain the lower and upper date range

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

Mike
 
Back
Top