Hi Mikewoodmsw,

This should do what you're looking for:

=CEILING(AVERAGE(E2:G2),1)

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mikewoodmsw wrote:
I want to add several cells, divide the result by the number of cells
and round that number to the nearest whole number.

e.g Round up (SUM E2,F2,G2)/2

Help