Hi,

Try this:

=SUMPRODUCT(--(MONTH(A1:A365)=C1),--(A1:A3650),B1:B365)
put the month number in C1, adjust to suit!

HTH
Jean-Guy

"George A. Jululian" wrote:

I have a real dates in column A from 01-Jan-2007 till 31-Dec-2007
and in B column I have Sales figures for each date
I need formula to give me total sales figures for June only or July only
your help is highly appreciated