Cell References in Functiona
 

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 DB7:DM7 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

Hi Mark

Look in HELP for the INDIRECT() function

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Mark T." <Mark wrote in message
...
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 DB7:DM7 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