Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My chart in Excell will only let me use 5 dates. ? | Charts and Charting in Excel | |||
auto locking of excell workbook (excell 2003) | Excel Discussion (Misc queries) | |||
Is there a way to automatically add sequential dates in excell? | New Users to Excel | |||
DATES IN EXCELL | Excel Discussion (Misc queries) | |||
Can excell notify me of due dates? | New Users to Excel |