SUM formula - using variable values

M

Mike C

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
 
J

John Michl

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
 
M

Mike C

I'll give it a try.
My co-worker hollared to me that is seems to do the trick.
Thanks for your hint.
 
Top