Sorry, I should have given a little more background. These circular
references are necessary (there is a budget which has entries that are
% of the total budget). So is there a way to have a separate cell that
keeps track of this without causing a circular reference? And the hard
part is this has to be done without the use of macros.


--
mattflow
------------------------------------------------------------------------
mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=388501