totaling & averaging a spreadsheet

S

SHARON

i have a spreadsheet containing:
employee, date, qty of errors, comments

it contains many rows if inputed information in order by date inputted
(sorted by date) employees are listed each time they issue a document. This
spreadsheet is tracking how many errors they make on these documents.

i need to calculate: 1) number of times each employee is entered, 2) Average
error per each document per person, 3) average error per document for all
employees as a whole.

Can anyone help?
 
P

porter444

I think I can help Sharon. I am home sick today, and am bored to death. Can
you email me a sample of your workbook? Please remove any confidential
information.

Send to: [email protected]



--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott
 
Top