I am looking for a way to temporarily remove a cell or cells from a
summed column without losing the contents of the cell.

Something similar to, "if A90 then C9, E9 , G9 =0" and then be able to
restore the original contents of C9, E9 & G9 by returning the value of
A9 to 0. The effect being to take out an area of computations to see
the change to the bottom line and then restoring those computations.

Any and all suggestions eagerly received and entertained.


--
Mr. Green Genes
------------------------------------------------------------------------
Mr. Green Genes's Profile: http://www.excelforum.com/member.php...o&userid=34472
View this thread: http://www.excelforum.com/showthread...hreadid=542343