Excel 2007 Question

[blunomore]

I am trying to add up the amounts in 3 cells by using this formula: =SUM(F95:F149:F161)

I gives me R0.00 as a result.

What am I doing wrong ?

Thanks

 

[Drake2007]

That's a range you're using try =sum(F95,F149,F161)

alternatively =F95+F149+F161

usually you use sum to add a range of cells, say you wanted to add all the values in the rows from F9 to F149 then it would look like this
=sum(f9:f149)

 

[blunomore]

That's a range you're using try =sum(F95,F149,F161)

alternatively =F95+F149+F161

usually you use sum to add a range of cells, say you wanted to add all the values in the rows from F9 to F149 then it would look like this
=sum(f9:f149)

I did what you suggested and still get an answer of R0.00 ...

EDIT: My PC is crazy!! I opened a previous excel doc to see how I did it there. I then closed it and went back to the one I am busy on ... and now suddenly the formula works ! How odd!

Thanks for the help, by the way

 

[Smiley_lauf]

or do this:

=SUM(while pressing Ctrl do <click cell1>, <click cell2>, ), then press enter

 

[Drake2007]

I did what you suggested and still get an answer of R0.00 ...

Then the answer is R0.00

 

[chickenbeef]

The format of the cells you want to add need to be in currency

 

[SirFooK'nG]

just type ="sum(" then hold your Ctrl key and click on each cell you want to add.

Make sure the cell formats are all the same

 

[Drake2007]

The format of the cells you want to add need to be in currency

That's probably the issue, OP is adding strings instead of numbers.

Check what value's are in those cells you're wanting to add.

EDIT: ah well looks like you've got it working.

 

[blunomore]

Then the answer is R0.00

LOL! I hope not - this is my monthly invoice to our biggest client. I better get some figures in that cell

The format of the cells you want to add need to be in currency

I checked and they are all formatted correctly.

I changed an amount on the doc and now we are back to R0.00 again. Help ?

 

[Drake2007]

change the =sum(x,x,x) to =concatenate(x,x,x) and post the answer here..

 

[murraybiscuit]

...assuming the value of the cells is something other than 0

 

[blunomore]

change the =sum(x,x,x) to =concatenate(x,x,x) and post the answer here..

I did something else. I deleted the entire row in which my total had to appear, inserted a new row and entered the formula, which seems to work. I presume this means there was something wrong with the formatting of that row.

Thanks

 

[chickenbeef]

Press F5 or F9 can't remember which one exactly, it will recalculate (refresh) all the formulas.

 

[ChilliGirl]

Have you tried the "calculate now" function or pressed F9?

 

[RexxGrim]

EDIT: My PC is crazy!! I opened a previous excel doc to see how I did it there. I then closed it and went back to the one I am busy on ... and now suddenly the formula works ! How odd!

Your workbook is probably set to manual Calulation - this will explain why the formula worked when you reopened the workbook. Click on the office button and go to Excel Options. There will be a option "formulas" were you can check if your workbook is set to manual calc or auto calc.

I've often seen this happen in 2003 were this option changes to manual for some reason.

F9 should recalc worksheet as well.