Value should not cange in cell A15

Closed
Report
-
 rayh -
Hello,


this is chandu. if w e sum A1: A10 in A15 and if we delete the values in that cells A1: A10 the value should not cange in cell A15. for that which command i have to use pls help me with ur suggestions.

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
there must be many ways to do it. I suggest data validation.
Because cell A15 contains a formula it value will change whenever the values it is summing changes.
You can copy, then paste special, values to retain the value.