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.

"Mr. Green Genes" wrote:


JMB Wrote:

In C9 enter

=IF(A90,0,value)

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




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.


--
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

[/color]