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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George A. Jululian" wrote in
message ...
Yes real dates in coloum A and numbers in coloum B to be sum

regards

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George A. Jululian" wrote in
message ...
Many thanks on your reply but it did not work

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George A. Jululian" wrote
in
message ...
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