Excel

[George A. Jululian]

dear all

I have one column in excel sheet filled in dates from 1/1/2007 till 31/12/2007
in second column sales figures for each date

I want a formula to sum all sales figures in June only moth or August month

Please help

 

[Don Guillett]

=sumproduct((month(a2:a22)=6)*b2:b22)

 

[George A. Jululian]

Many thanks on your reply but it did not work

=sumproduct((month(a2:a22)=6)*b2:b22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

It does work if you have REAL dates in col A and figures to sum in col B!
Exactly what did you do?

 

[George A. Jululian]

Yes real dates in coloum A and numbers in coloum B to be sum

regards

 

[Don Guillett]

Then, if is still "doesn't work", you need to fully explain what that means
along with posting YOUR formula.

 

[George A. Jululian]

i want to thank you for great help
your formula works very good

Regards