sum formula not working excel 03
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?
|