Maintain Value of SUM function even if referenced cell value changes

[Urzu1000]

Hi folks,

Is there a way to make a value "stick" in Excel? For example...

Let's say I have Cell A1 as =SUM(B1:B5) to add up the cells B1:B5 and display the results in cell A1. Piece of cake.

But what I want is for cell A1 to KEEP the sum even if the contents of B1:B5 get cleared.

Thank you for your help in advance! I can't find a way to do this for the life of me.

 

[arthurbr]

Perhaps adapt this technique using the SUM function?

 

[Urzu1000]

Thank you for the link arthurb! I think this new info gives me enough to go on so that I can figure it out!

 

[arthurbr]

You're welcome
Be aware there are other techniques using VBA that can be used also