Spreadsheet Formulae To Calculate A Column Of (Money) Figures.

[Theseeker123]

Hello all ! I`m trying to create a simple formula to add up the total of a column of figures (money), in a spreadsheet. I`ve looked at the "simple" guides on the `net, but found them far from simple. I`m using Open Office, and their guide is not clear even when you find the right bit to look at!
All I want to do is add a whole column (which I`ve done several times with calculator) but end up with several answers!

Please Help.

[murraymints]

go to empty cell at bottom and autosum

[murraymints]

https://www.google.co.uk/search?q=sum+total+on+spreadsheet&oq=sum+total+on+spreadsheet&aqs=chrome..69i57.9979j0j7&sourceid=chrome&ie=UTF-8

[sunny-dave]

In the cell in which you want the answer, enter

=SUM(A1:A14)

where A1 and A14 are the cells containing the first and last items in the list.

[Peter Pedant]

if it is excel related put your cursor flashy thing at the bottom
then try ....... alt =

I dont use your prog
but for xcel - which is worth buying
I have found you tube
https://www.youtube.com/user/ExcelIsFun

and this set of viddies
https://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw

very useful
especially recorded for accounting learners and FREE

[Theseeker123]

Thanks sunny-dave, succinctly put! Though you could have mentioned pushing the green tick!
I did manage to get the total right manually though 3 times out of 5.
Thanks also to murreymints!