Saving a sum

F

fishy

I want to find the sum of a series of cell values, then delete those values
and just keep the sum. Is there a way to keep that sum then change the value
of the cells included in the sum?
 
N

Norman Jones

Hi Fishy,

With the sum cell selected:

Edit Copy | Edit Paste Special | Values | OK.

This will freeze the snapshot sum value and you can then change/delete the
series cell values without altering the original sum..
 
Top