I’m a newbie at excel and have, I think, a basic question.

I have a SUM(G2:G5). When I include a value at for example G3 the sum area expands to G2:G6, but when I include values at the top (G2) or at the bottom (G5) excel doesn’t include the new value in the range.

Please, help! SUM($G$2:$G$5) doesn’t seem to help.