ExcelBanter - SUM by month

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUM by month (https://www.excelbanter.com/excel-worksheet-functions/120551-sum-month.html)

Mortir

SUM by month

i have the following case:

DATE Ammount
01.12.06 50
05.12.06 100
12.12.06 200
25.12.06 240
01.01.07 200
15.01.07 210
27.01.07 111
etc...

I would like to SUM the ammounts by month

month ammount
dec. 06 590
jan. 07 521

how do I do that?

thanks!

Bob Phillips

SUM by month

=SUMPRODUCT(--(YEAR(A2:A8)=2006),--(MONTH(A2:A8)=12),B2:B8)

--
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Mortir" wrote in message
oups.com...
i have the following case:

DATE Ammount
01.12.06 50
05.12.06 100
12.12.06 200
25.12.06 240
01.01.07 200
15.01.07 210
27.01.07 111
etc...

I would like to SUM the ammounts by month

month ammount
dec. 06 590
jan. 07 521

how do I do that?

thanks!

All times are GMT +1. The time now is 10:24 PM.