GLS,
I've stumbled through this before, without a good solution.
Clumsy solutions which I've used and which you may try are to either
(a) re-write the formulas to use vlookup or sumif features, or (b) use
helper calculations on another worksheet. When you sort the main
worksheet, the references to the helper sheet remain correct.
--
rsenn
------------------------------------------------------------------------
rsenn's Profile:
http://www.excelforum.com/member.php...o&userid=29050
View this thread:
http://www.excelforum.com/showthread...hreadid=490197