I have the problem with excel´s function SUM.

A1=A2 A2=amount(A3:A6)

I need blocked A1, when I change some number for example A5. A1 contains the number before the change.

Mrice thought the macro, but this macro switched off all function. and I have around 120 sum in excel list. It is crazy, because I must validate each formula.

I reflected. Is it possible, the mathematical formula after the calculation assign to standart number(enter the keyboard).

I know, it is stupidity, but I have any idea to solve it.