I didn’t understand what you wanted to say. But I found a workaround for it. I calculate the sum of all the numbers again.
While further exploring, I found that the data in a formula cell should not be used as an input in another formula cell. Otherwise, the succeeding formula cell uses the older value of the preceding formula cell. I wanted to understand the reason why is there such a functionality. Can you tell me how formula cells function and when do they take values?
P.S.:
- A cell having a formula dependent on the cells with static data gives desired output.
- A cell having a formula dependent on other cells which themselves depend on another formula doesn’t produce desired output.