Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Columns represent days of the month (E2 is day 1, F2 is day 2, etc), rows
represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo day 2, etc.) How can I sum the rows based on a begin and end date? Example: Begin date is March 10, end date is March 15, I need row 3 summed for the range of columns that are within the from and to date range. 3/1 3/2 3/3 3/4 etc. category 1 50.00 5.00 2.00 3.50 category 2 1.00 10.00 .75 .25 I need the formula result to show on another sheet in one column for each row, I suppose I could just copy the formula down the column. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to check if date falls within range | Excel Worksheet Functions | |||
Computing a date range | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Need to find Min value based on date range entered | Excel Worksheet Functions |