| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Define variable range input for SUM() function
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "JeffC" wrote in message ... Thanks! That did it! "T. Valko" wrote: Try it like this: =SUM(F6:INDEX(F6:I6,F4)) If F4 is an empty cell the entire range will be calculated. -- Biff Microsoft Excel MVP "JeffC" wrote in message ... I'm still working through this... but why doesn't the following formula work? =SUM(INDIRECT(INDEX(F6:I7,1,1):INDEX(F6:I7,1,F4))) ... where F4 equals an integer representing a month/column in the range? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I define validation range by function? | Excel Worksheet Functions | |||
| Define Variable Name using VBA | Excel Discussion (Misc queries) | |||
| Variable range in MAX-function | Excel Worksheet Functions | |||
| Variable Input Range for Combo Box | Excel Worksheet Functions | |||
| Macro - define cell range for a sum function | Excel Discussion (Misc queries) | |||
Threaded Mode
