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?
--
David Biddulph

"wynand" wrote in message
...
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?