Lock Data Results in cell's while changing the data that populated it?

[SnKeaK]

So in A1, I would like to add the total of all cells in COL B.

The thing I'd like to do however is be able to edit COL B again with fresh sets of info, but A1's previous data does not change. Kind of like locking in A1's results so I can move on to A2, enter data in COL B to recount the new data, and lock those results in A2. and so on.

I have no idea what functions would do this, or if it's even possible. Just checking with the pros to give me guidance. Thank you.

= SUM(B1:B4)	7
	5
	19
	2

 

[myall_blues]

It's not possible to do what you want without using VBA. Formulas in Excel are always dynamic.

 

[SnKeaK]

It's not possible to do what you want without using VBA. Formulas in Excel are always dynamic.

Thank you. Do you have any suggestions of a better way of inputting data into COL A automatically? As of now, I'm thinking just keep the formula as is, after it calculates all, retype the number in the cell, effectively removing the formula.

 

[myall_blues]

Describe to us your requirements and what you're trying to achieve in the real world and we can probably provide a solution. Is VBA an option for you?