View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
wynand wynand is offline
external usenet poster
 
Posts: 54
Default 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?