# how to sum a column

I know I can find the sum of a column by entering "=D1+D2+d3..." but there's got to be a shorter way and I don't remember it. Please help.

First time here? Check out the FAQ!

0

I needed values in Column F to display a "running total" of all values from a fixed upper cell in E (i.e. the start date) down to the current row which represents the current date (i.e. a new row of data is added each day).

At first I thought this was a simple matter of summing all values in E... for which Grantier's answer works well. However, in keeping with the spirit of maintaining a running total, I realized what I *really* needed was a sum of the current day's value in E with the previous day's value from one row higher in F.

For that I used "=SUM(F4+E5)" in the F5 cell and then used the "fill handle" in the bottom right corner of F5 to drag that formula down column F as far as needed.

Either way seems to work. I think the second method is more appropriate for my task at hand. Thanks for helping me with this! Most of my spreadsheet work was done over 20 years ago in the mid-1990s so I'm a bit rusty. Fortunately, it comes back to me quickly when I try to remember it. Amazing how so little has changed in all this time!

0

Try this:

```
=SUM(D1:D3)
```

The column was Currency. I changed it to Number, removed the currency symbol, aligned the figures, and then copied to a new page. The numbers do not add, I simply get the first number in the column. Grantier's example has a space after SUM and before the ( and another space before the : and I tried the formula with this spacing and with no spacing. It still does not add.

1

There is no space between SUM and ( above.. anyway, spaces are cosmetic and don't affect the formula.

Your numbers still not adding indicates the cell content really is of type Text instead Numeric. Please *follow* the procedure given in the FAQ above. Just changing the number display format and aligning content does not re-enter values. The values have to be **re-entered** after the number format was changed to something different than Text. Copying cells does not change anything.

0

Asked: ** 2018-05-21 20:00:48 +0200 **

Seen: **15,751 times**

Last updated: **Feb 10**

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.