Hi,
i have the following problem

cell A1= 1
cell A2 = 2
cell B1= A1+A2

so cell B1 displays 3

but i want to name the cell B1 as SUM and want it to display as SUM while it should store the value (A1+A2) even as A1 and A2 keep changing. And also use cell B1's value further in other cells for more calculations without affecting its display name SUM. is that possible?

cheers

Ananth