Cell References in Functiona

[Guest]

I am trying to insert cell references in a function that are values in other
cells and I'm getting a function error.

Cell A1 contains a formula the returns the text value DB7
Cell B1 contains a formula the returns the text value DM7

I want to sum the range of cells between the cell range DB7M7 but since
the range can vary, I want to be able to pull in the values from A1 and B1 to
form my Sum() funciton. I though I might be able to simple say =Sum(+A1:+B1)
to draw in the values of A1 and B1 but it gives me a fucntion. How to I make
it happen?

Thanks,
-Mark

 

[Niek Otten]

Hi Mark

Look in HELP for the INDIRECT() function

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel