Excel

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

Guest

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
 
Many thanks on your reply but it did not work

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 
It does work if you have REAL dates in col A and figures to sum in col B!
Exactly what did you do?
 
Then, if is still "doesn't work", you need to fully explain what that means
along with posting YOUR formula.
 
Back
Top