When I change the formula to read as you specifiied, I lose all data. I have
a #VALUE error on all cells. Is there no way to kepp the cell referece data,
inside a formula, maintain that cell data integrity. The formula
=sum($a$5+$b$5+$c$5)*$w$1 does not allow me to sort the data by any particlar
column. The data that is in each of the specified cells, does not follow with
the sort procedure. Is there a solution to this problem? I tried removing the
absolute cell refences, but that didn't work either.
Any help would be appreciated.
John

"bj" wrote:

I do not understand what you need, but check out the indirect() function in
Help.

=indirect("AA31") will always refer to AA31, no matter what you do to the
spreadsheet.

"MarcoPolo" wrote:

I have a rather large worksheet, columns to AN, rows to 369, and currently
transfers data across about 6 worksheets with more to come. I'm building a
price list with a long list a variables and then setting the prices into a
special format, so I cannot afford the data loss. When I sort my list for a
variety of reasons, the formula references do not maintain the original cell
references I need. I tried the absolute reference, bad idea. totally lost the
information. Had to rebuild. Tried partial absolute refernces, some success,
but a big loss on some.

Is there a good way to build a formula that will allow for cell references
to remain intact under various data sorts?
Thanks in advance!
John