sum by dates-Excell 2003
 

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?

sum by dates-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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Zirt" wrote:

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?

sum by dates-Excell 2003
 

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 cells
containing the likes of:
2003 Q1
2003 Q2
2003 Q3
etc.
Zirt;429630 Wrote:
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?


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

--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119373