Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum a column based on a date
I have invoice dates in Column A and their dollar amount in column F. I would like to have another cell say January. And each invoice with a date in January would be added there to make the Total for all invoices in January. Is there a formula to do this? -- karstens ------------------------------------------------------------------------ karstens's Profile: http://www.excelforum.com/member.php...o&userid=17657 View this thread: http://www.excelforum.com/showthread...hreadid=493626 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum a column based on a date
=SUMPRODUCT(--(YEAR(A2:A200)=2005),--(MONTH(A2:A200)=1),F2:F200)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "karstens" wrote in message ... I have invoice dates in Column A and their dollar amount in column F. I would like to have another cell say January. And each invoice with a date in January would be added there to make the Total for all invoices in January. Is there a formula to do this? -- karstens ------------------------------------------------------------------------ karstens's Profile: http://www.excelforum.com/member.php...o&userid=17657 View this thread: http://www.excelforum.com/showthread...hreadid=493626 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum a column based on a date
Thank you Bob! That worked. I really appreciate your help! -- karstens ------------------------------------------------------------------------ karstens's Profile: http://www.excelforum.com/member.php...o&userid=17657 View this thread: http://www.excelforum.com/showthread...hreadid=493626 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating "Todays Date" column upon opening? | Excel Discussion (Misc queries) | |||
Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
LINK ONE ROW BASED ON CONTENTS OF A COLUMN WITHIN THE ROW (DATE) | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |