Round values before SUM()

Question

Our customers use formulas in their input fields. Thats why their values sometimes contain decimal places. We can't round each field, cause it would be overrided by their formulas and input. I have a field, which requires numbers with no decimal places. Is there a possibility to SUM() the ROUNDED values, something like a ROUND() function that uses a range of inputs?

Accepted Answer

I think what you may want is something like this:

```
=SUM(ROUND(A1:C1,0))  
```

entered with Ctrl+Shift+Enter. The `0` is for the extent of rounding (no decimal places) but can be increased. So with data in each of A1:C1 (the range may be increased) of `12.4` the result is `36`, with data of `12.6` the result is `39`.

Round values before SUM()

Solution

Problem