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 A9>0 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.
Bookmarks