Anyone know how to get things to add up in excel

facingthefuture

I am doing up our accounts in excel for the accountant (trying to cut costs).
Anyway, doing it in a basic way
date / invoice no /description /amount

So far I have everything entered in. How do I get it to add up say 12 figures in a column?
(I failed my maths gcse 4 times, fifth time I got it but it still hate maths).

Incidentally,it explains why we have never any money. Crikey we do pay out a lot in expenses. My dad said "make sure you do your books honestly" Frankly I wouldn't be clever enough to do anything else even if I wanted to (which I don't). Still your health is your wealth.
Thanks.

Idiophreak

find the cell you want the total to display in, click in it...
type
=SUM(
then select the cells you wish to add up
then type
)
and press enter...job done

facingthefuture

:DIdiophreak, you are absolutely fantastic. Seriously, if I was near you I would be trying to hug you. Wow that makes such a difference!!!!!!!Thanks.:D

greengrass

An even easier way - look along your top tool bar for an icon called autosum. That will add all the numbers above it together.

facingthefuture

Brilliant, I am so chuffed. Thanks to you both.

Nile

Hello facingthefuture

I'll move your thread to the 'Techie Stuff' board, where it might help someone else who is new to excel.;)

Hi, Martin’s asked me to post this in these circumstances: I’ve asked Board Guides to move threads if they’ll receive a better response elsewhere(please see this rule) so this post/thread has been moved to another board, where it should get more replies. If you have any questions about this policy please email [EMAIL="abuse@moneysavingexpert.com"]abuse@moneysavingexpert.com[/EMAIL].

Regards

Nile

superjaggybunnet

If you click on the first figure and hold the mouse button down while dragging over all the rest the total is shown in the total bar at the bottom of the screen. Right click on that number for other options.

It doesn't total them in your actual spreadsheet but you may not want to total all of them and this is a quick way of getting a sub-total.

C_Ronaldo

OP if you use the 1 excel sheet for the accounts eg you have the collums for each of the months ins and outs then to get a total colum for each month all you need to do is click on a box with a total in and just drag it by using the bottom right corner of the box