Spreadsheet help?

Question

Im making a budget and can figure out for the life of me how to add everything up, can someone help me?

Answer 1

put your cursor in the cell where you want the total and type:

=sum(a1:a12)

a1 thru a12 are where the figures to add up are.

good luck :)

Answer 2

The squares are called cells. They have a letter and a number to tell you what cell you're talking about - the letter and the number on the edges of the sheet intersect. for instance, the top left cell is A1, next to that A2, below that B2 etc.

To add up a series of cells, just use the formula =sum(firstcell : lastcell)

So, if you wanted to add the first column, from A1 down to J1, you'd put the cursor in the cell where you want the answer to appear and say =sum(A1:J1)

Answer 3

There are a couple different ways to do it. If you have a list of amounts that you just want to add up then just highlight what you want to add up and then click on the funny shape at the top of page or if you want the comp to continuously add it up for you you can tell it what all columns to add up by for example you want to designate column A rows 1 thru10 and you want the answer to be in row 12 then you will go to row 12 and and put =A1+A10 and it will add all of them up for you. You can do it by going to the cell you want the answer in and typing = and then clicking on the cell you want and typing + or - whichever you want and then clicking on the other cell you want in the equation and then hitting enter it will do the same thing you can just pick out which cells you want to put in the equation. Hope this helps.

Answer 4

if all the numbers are in one column, then in the box where you want the total to be, put in "=sum(a:a)" but the total box cannot be in column a. if you just want certain boxes to add up, put "=a5+a6" (or whatever the name of the cells or boxes are). there are the letters across the top and numbers down the side to name the cells.