You're welcome!

Hoib wrote:
Perfect! It works as advertised! Thanks a lot!


"Debra Dalgleish" wrote in message
...

You can use the Indirect function: =SUM(INDIRECT("A1:A10"))

Hoib wrote:

Have a simple idea that is giving me fits.

Have a worksheet with numberic data and labels in rows and columns.
Below each column I use a simple SUM() function which works fine, until I
disturb a row of data. By disturb, what I mean is that if I move the top
row of data down to the bottom of the array, highlight the entire data
area, move that area up one row, I lose the correct references in the
SUM() function. I'm just moving the data area, not the row containing my
SUM() functions - that stays put. IOW, the SUM() function is in row 12,
the data area extends from row 1 through row 10, I move row 1 to row 11
and then move everything from row 2 through row 11, back up one row.

I've tried using relative and absolute addressing but that SUM() formula
somehow keeps adjusting based on what it sees me moving and giving me an
incorrect result. How do I make the formula "static", or to just tell it
"sum the numbers above and don't watch what's moving around, dog-gone
it!".

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html