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!

--------------------
(Ms-Exl-Learner)
--------------------


"wynand" wrote:

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