Ask Your Question

How do I add totals in a column

asked 2019-08-18 15:57:58 +0200

blackie4403 gravatar image

I just want to add amounts in a column eg. b7 to b15

edit retag flag offensive close merge delete


Trying not to assume too much from the wording of your question, there are several methods that you could use, but


is probably the most straightforward and easiest to understand. You could check the help file to see other possibilities.

ve3oat gravatar imageve3oat ( 2019-08-18 16:13:02 +0200 )edit

More details.

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-08-18 16:14:50 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-10-22 21:20:36 +0200

1meek1 gravatar image

Using the SUM function would help you. Which is what @ve3oat suggested :-) Are you having an issue with that working? Some people are trying to add a range like that and getting zero. (i'm one)

edit flag offensive delete link more


Usually it happens when cells contains numbers as text not true numbers, for those only direct references works, not ranges.

m.a.riosv gravatar imagem.a.riosv ( 2019-10-22 22:36:54 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-18 15:57:58 +0200

Seen: 49 times

Last updated: 2 hours ago