sum by dates-Excell 2003

[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?

 

[Luke M]

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)