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..
---
Regards,
Norman
"fishy" wrote in message
...
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?
|