Could you give us the equation - is it the number of rows for an employee/total rows for the dept? You also left your employee names in on the far right of the sheet if that matters.
Thanks - replaced the file.
For example, I'm looking to compare the average SUM_HTML for a month for the EDGAR department to a specific employee's performance.
Thanks for the quick reply. I think Total may be what I need.
Let me review and I'll get back to you.