Rounding multiple cells

[Richard_McConnell]

I am tracking travel expenses for employees. They receive an allowance each time they visit a given site but may not stay the whole day. Their site attendance record may show that they spent, say, 2.5 days on that site during a particular week but this equates to 3 travel allowances. The round function would apply perfectly here. However, I am looking to show a cost for all staff on that site during any given week. I would therefore like to round each staff's site attendance in a single abbreviated formula if possible. I have tried using =ROUND(D18:D35,0) for example, in the hope that it would round each figure separately before giving a total but this just returns a #VALUE!

Any ideas would be most welcome. Thank you.

 

[SteveO59L]

suspect you would need to round each individual entry, not the sum of entries to get the answer you require

 

[Richard_McConnell]

Thanks. I was hoping to avoid that if possible. I realise that a straightforward sum of the values and then rounding would return a inaccurate figure but I hope there might be a single formula to first round up the entries and then provide a total. Too ambitious perhaps!

 

[SteveO59L]

you could do that with code, but would not give you the audit trail of how the value was calculated, so would need to go back to rounding the individual entries to check, bit self defeating