sum formula not working excel 03

[wynand]

The formula:
=sum(h10,h14,h20,h40)
The result should be:
=sum(4,5,4,4,4,) =21
I however get 20 as a result.
Tools/Options is set to automatic and the "h" cells are formatted as numbers
(1234).
The cells are dependent on other formulas (=sum(h11:h12)/2) etc. The cells
in between is formatted to numbers (1234.10)

Any suggestions anyone

 

[Jacob Skaria]

Check out whether h10,h14,h20 and h40 contain real integers..or are rounded
off. Increase the decimal points of these cells and check ..

 

[Ms-Exl-Learner]

First of all check the number of cell reference you have mentioned in your
sum formula.

=sum(h10,h14,h20,h40)

1-H10
2-H14
3-H20
4-H40

In the above sum function you have referred 4 cell references.

But in your next example (i.e.) =sum(4,5,4,4,4,) =21
1-4
2-5
3-4
4-4
5-4
The numbers of values are mentioned is 5.

So correct your example and provide the clear picture of your problem.

Remember to Click Yes, if this post helps!

 

[wynand]

The cells are rounded off (no decimals),
so therefore 4+5+4+4+4 should be 21 and not 20
If I use the array formula
=sum(round(h10,h14,h20,h40,1))
I get to 21 as a result
Would this formula suffice or would it affect something else I'm not aware of?

 

[David Biddulph]

I'm surprised that you say that you use =sum(round(h10,h14,h20,h40,1)) and
get 21 as a result. With Excel 2003 that formula flags a syntax error, as I
would expect it to do. Which Excel version are you using?