Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Okay, I see that I neglected to click the SUM symbol.

(This is not the answer!)

So now I click the Equal then the SUM symbol while my cursor is in the cell below the series, then click in the top cell and drag through the cells in the series.

In the tool bar field, what shows is =SUM(A1:A8)

But in the cell below, the number that comes up is ZERO (0), even though the numbers in the series most definitely do NOT equal zero.

Now, when I go back to do it again, it gives me the number that is in the bottom cell of the series, not the sum of the series, even though the formula remains the same: =SUM(A1:A8).

What gives?

(This is not the answer!)

Okay, I see that I neglected to click the SUM symbol.

(This is not the answer!)

So now I click the Equal then the SUM symbol while my cursor is in the cell below the series, then click in the top cell and drag through the cells in the series.

In the tool bar field, what shows is =SUM(A1:A8)

But in the cell below, the number that comes up is ZERO (0), even though the numbers in the series most definitely do NOT equal zero.

Now, when I go back to do it again, it gives me the number that is in the bottom cell of the series, not the sum of the series, even though the formula remains the same: =SUM(A1:A8).

What gives?