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

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

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