Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM formula - using variable values
Is it possible to substitute the cell range values in the SUM formula with
calculated cell range values (having used a single formula that consists of ADDRESS, ROW, COLUMN, INDEX and MATCH functions)? It appears that Excel is throwing quotation marks around my generated cell range values in the SUM formula, thus returning an error. Can I get around this somehow? ((I am attempting to have Excel automatically calculate a month-to-date sum of numbers based on the dates in my sheet.)) Ver: Excel2003 Platform: XP -- Thanks, Mike |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM formula - using variable values
I'm not exactly sure what you're trying to do but you may look at the
INDIRECT function if you are trying to create the references within the formula. - John Michl |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM formula - using variable values
I'll give it a try.
My co-worker hollared to me that is seems to do the trick. Thanks for your hint. -- Mike "John Michl" wrote: I'm not exactly sure what you're trying to do but you may look at the INDIRECT function if you are trying to create the references within the formula. - John Michl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
array formula values | Excel Discussion (Misc queries) | |||
SUMIF where values to be summed are formula | Excel Worksheet Functions | |||
manipulating formula values | Excel Worksheet Functions |