=SUMPRODUCT((Year(A1:A100)=2008)*((MONTH(A1:A100)= 8)+(MONTH(A1:A100)=9))*B1:B100
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"NumbersDevon" wrote in message
...
Hi
I have a spreadsheet with this strucure and I want to fill cells that have
sums of the entries in each year

A B
20/09/08 100
31/08/08 200
15/09/08 150

need a cell with the total of all values in column B in the month of 09/08
then 08/08 etc

total would be 250

Please help


--
NumbersDevon