Haven't you answered the question yourself, calculate the average per
department based on the number in that department.

Other than that, you have given us nothing to go on.

--
__________________________________
HTH

Bob

"ArcticWolf" wrote in message
...
Hi,

I calculate Sickness and Absence (S&A) data for my company, by department.
Each department can have between 5 - 100 people in it. I currently do a
S&A
% of the department and then as company as a whole.

Because in one team we could have 5/10 people off = 50% S&A rate, yet in
another department 5/100 = 5%.

Is there a better way of calculating the % S&A for each department that
will
give more meaningful data?

Thanks in advance,

AW