Problem No. 1 office doesn’t auto update (recalculate based on what you type in):
A1= 2 B1=2 C1=2 D1=sum(A1:C1) or “6”
delete cell A1 and D1 still = “6”
2.) I’m slowly making a list with shifting values, for top least valuable to bottom more value.
So I shift A1:C1 down… and…
D1=(A2:C2) or “6”… when it should be zero… it tracks those 3 cells I’m moving around… I don’t want it to.