Sum IF with Dates

[lmb23]

Help please. I have a series of events listed by the date which they occur and I would like to write a SUMIF, which will return the sum for a given month. The data series is listed as follows:

17-Aug-09 $560,000.00
28-Aug-09 $266,400.00
04-Sep-09 $335,093.00
01-Sep-09 $225,000.00
08-Sep-09 $114,750.00
26-Aug-09 $260,000.00
28-Aug-09 $588,650.00
28-Sep-09 $129,000.00
17-Sep-09 $378,473.00
15-Sep-09 $360,000.00

September =
August =

[teylyn]

Hi,

for September you can use

=SUMPRODUCT((MONTH(A1:A10)=9)*(B1:B10))

or

=SUM((MONTH(A1:A10)=9)*(B1:B10))

The second formula must be confirmed with CTRL-SHIFT-ENTER. It is an array formula.

For August, change the red bit to be 8

hth

[lmb23]

The array works perfectly, thank you very much!

[DonkeyOte]

If you're doing this for each month you might want to consider pushing your data into a Pivot Table such that:

Date is Row Field -> grouped by Month (& Year if necessary)
Revenue is Data Field set to SUM.

Pivot Tables will offer you immense reporting flexibility for little / no effort .. if you're unfamiliar with them there is a general intro link in my sig.