How to turn a cell "OFF" or Null it's Contents?

[Mr. Green Genes]

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.

 

[Guest]

In C9 enter

=IF(A9>0,0,value)

where value is the value you want if A9 is zero. Use as similar formula for
E9 and G9.

 

[Mr. Green Genes]

In C9 enter

=IF(A9>0,0,value)

where value is the value you want if A9 is zero. Use as simila
formula for
E9 and G9.

[/QUOTE]


This isn't quite what I'm looking for. I want to be able to remove ~1
cells in a row and then restore them. Similar to deleting them the
using the undo. Except I just want to turn freeze the cells as if the
had a value of zero then be able to turn them back on

 

[Guest]

If the cells are part of a summed range and you want them excluded from the
total, you can use Subtotal instead of Sum, then hide the rows with the cells
you want excluded. Subtotal excludes hidden rows while Sum does not.



This isn't quite what I'm looking for. I want to be able to remove ~10
cells in a row and then restore them. Similar to deleting them then
using the undo. Except I just want to turn freeze the cells as if they
had a value of zero then be able to turn them back on.
[/QUOTE]