sum by dates-Excell 2003

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

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)
 
P

p45cal

See attached with notes included. It includes one formula:
=SUMPRODUCT(IF(YEAR($A$2:$A$170) & " Q"
MOD(INT((MONTH($A$2:$A$170)-1)/3),4)+1=E2,$B$2:$B$170,""))
which should be array-entered, which refers to adjacent cell
containing the likes of:
2003 Q1
2003 Q2
2003 Q3
etc.
Zirt;429630 said:
I have a spread sheet with dates in column "A" and numbers in colum
"B". I
would like to sum part of column B based on dates in column A (b
quarters,
Jan-March, April-June, etc...)

Can anyone tell me if it can be done in Excell 2003
Click to expand...

+-------------------------------------------------------------------
|Filename: Summing according to dates.xls
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=194
+-------------------------------------------------------------------
 
Top