sum by dates-Excell 2003

  • Thread starter Thread starter Zirt
  • Start date Start date
Z

Zirt

I have a spread sheet with dates in column "A" and numbers in column "B". I
would like to sum part of column B based on dates in column A (by quarters,
Jan-March, April-June, etc...)

Can anyone tell me if it can be done in Excell 2003?
 
Sure thing. Take a lookat SUMIF in help file.
Example for first quarter:
=SUMIF(A:A,">="&DATEVALUE("1/1/09"),B:B)-SUMIF(A:A,">"&DATEVALUE("3/31/09"),B:B)
 
Back
Top