Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column by Date Range
I have 2 columns, one with date the other with $amounts. I want to sum the
$amounts, but only by a date range,(ie 2/10/07-9/07/07). Date Amount 1/1/2006 125 2/10/2007 50 9/07/2007 25 I need help with a fomula for this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column by Date Range
One way:
=SUMIF(A1:A3,"="&DATE(2007,2,10),B1:B3)-SUMIF(A1:A3,""&DATE(2007,9,7)) Better to use cells to hold the date range: D1 = 2/10/2007 E1 = 9/7/2007 =SUMIF(A1:A3,"="&D1,B1:B3)-SUMIF(A1:A3,""&E1,B1:B3) -- Biff Microsoft Excel MVP "Lexi" wrote in message ... I have 2 columns, one with date the other with $amounts. I want to sum the $amounts, but only by a date range,(ie 2/10/07-9/07/07). Date Amount 1/1/2006 125 2/10/2007 50 9/07/2007 25 I need help with a fomula for this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column by Date Range
THANKS, WORKED GREAT!!!
"T. Valko" wrote: One way: =SUMIF(A1:A3,"="&DATE(2007,2,10),B1:B3)-SUMIF(A1:A3,""&DATE(2007,9,7)) Better to use cells to hold the date range: D1 = 2/10/2007 E1 = 9/7/2007 =SUMIF(A1:A3,"="&D1,B1:B3)-SUMIF(A1:A3,""&E1,B1:B3) -- Biff Microsoft Excel MVP "Lexi" wrote in message ... I have 2 columns, one with date the other with $amounts. I want to sum the $amounts, but only by a date range,(ie 2/10/07-9/07/07). Date Amount 1/1/2006 125 2/10/2007 50 9/07/2007 25 I need help with a fomula for this. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column by Date Range
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Lexi" wrote in message ... THANKS, WORKED GREAT!!! "T. Valko" wrote: One way: =SUMIF(A1:A3,"="&DATE(2007,2,10),B1:B3)-SUMIF(A1:A3,""&DATE(2007,9,7)) Better to use cells to hold the date range: D1 = 2/10/2007 E1 = 9/7/2007 =SUMIF(A1:A3,"="&D1,B1:B3)-SUMIF(A1:A3,""&E1,B1:B3) -- Biff Microsoft Excel MVP "Lexi" wrote in message ... I have 2 columns, one with date the other with $amounts. I want to sum the $amounts, but only by a date range,(ie 2/10/07-9/07/07). Date Amount 1/1/2006 125 2/10/2007 50 9/07/2007 25 I need help with a fomula for this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
Select a Range of column depending on the date | Excel Worksheet Functions | |||
select date range in column | Excel Worksheet Functions | |||
2 column lookup - match to date range | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |