How do I create the sum to add and subtract on an excel spreadsheet please?

Question

I am trying to create an excel spreadsheet for my income and expenditure over the year, and on a monthly basis. I used to be bale to do this but have forgotten the formulas. I have been trying: SUM=(B2*B9) to get a subtotal, but just end up with the formula in the subtotal box. Then I tried: Sum=(B2+B3+ etc, which didn't work either! What am I doing wrong? Any experts out there can help me please?

Answer 1

you are forgetting : thus =sum(b2:b9)
and the = goes first.
any other problems with it drop me a line.

Answer 2

I thought that if you want to add you put in the cell =B2+B3 then either press enter ot click on the green tick next to the formula bar.

If you want to multiply =B2*B3 etc

You can copy the fourmala too so you dont need to keep doing it.

Let me know if you need more help.

Answer 3

If you're trying to add the columns B2 to B9 I think you need a colon - ie SUM=(B2:B9)

Answer 4

first of all, make your column a little bit wider, if the formula won't fit then excel won't create it. Second the formula is =sum(b2:b9) for addition of the entire column
=sum(b2+b3) for addition of two numbers
=sum(b3-b2) for subtraction
=sum(b2*b3) for mulitplication
=sum(b2/b3) for division

Answer 5

Income - Expense = Sum(B2:B9) - Sum(B11:--)

Answer 6

Go to functions under "insert" and hit sum than hit the cells you want it to include. It's as easy as that.

Answer 7

in an excel spreadsheet there is no 'row A'. 'A' is a column, the rows are numbers. Please reformat your question with the proper terminology. Thanks.