I have a spread sheet of 461rows.  I went to the bottom and in row B I put in the following – =SUM(A3:A461).

At this time there are no numbers in that row – I have rows to the right that do and I was going to put that formula in those rows as well.

However, when I click away from where I put the formula1965352 comes up.  I put the same formula in the C row, which has numbers in it, and the same 1865352 comes up.

Help. – jb

​I have a spread sheet of 461rows.  I went to the bottom and in row B I put in the following – =SUM(A3:A461). At this time there are no numbers in that row – I have rows to the right that do and I was going to put that formula in those rows as well. However, when I click away from where I put the formula1965352 comes up.  I put the same formula in the C row, which has numbers in it, and the same 1865352 comes up. Help. – jb  Read More

​