sum formula not working excel 03

  • Thread starter Thread starter wynand
  • Start date Start date
W

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
 
Check out whether h10,h14,h20 and h40 contain real integers..or are rounded
off. Increase the decimal points of these cells and check ..
 
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!
 
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?
 
Back
Top