excel sales figures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Have you tried a pivot table. Select Data -> Pivot Table and follow the
wizard. Place the dates in the left hand column and the sales in the data
area.

Right click on the dates in the pivot table and select Group. Assuming you
have all dates with no blanks then it should have an option of Days, Months,
Quarters, years. Select the ones you want.

Everything is now grouped. There is more stuff you can do including
formatting and such...
 
Hi,

Try this:

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

HTH
Jean-Guy
 
Back
Top