Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select date range in column
I need to be able to sum one column based on dates in another column.
Thankful for any help on this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select date range in column
Hi!
Try this: D1 = start date E1 = end date Sum values in column B where the corresponding dates in column A fall within the date range (inclusive): =SUMIF(A1:A20,"="&D1,B1:B20)-SUMIF(A1:A20,""&E1,B1:B20) Or: =SUMPRODUCT(--(A1:A20=D1),--(A1:A20<=E1),B1:B20) Biff "garlocd" wrote in message ... I need to be able to sum one column based on dates in another column. Thankful for any help on this. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select date range in column
"garlocd" wrote:
I need to be able to sum one column based on dates in another column. One way .. Assuming real dates are within $A$2:$A$100, with values to be summed in $B$2:$B$100 Try something like this in say, C1: =SUMPRODUCT(($A$2:$A$100= -- "1-Jun-2006")*($A$2:$A$100<= -- "15-Jun-2006"),$B$2:$B$100) Adapt to suit, but note that entire col references eg: A:A, B:B, cannot be used in SUMPRODUCT -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
I need a formula to find rows within a date range in one column? | Excel Worksheet Functions | |||
Count cells based on date range in another column | New Users to Excel | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
adding occurrences for date range | Excel Discussion (Misc queries) |