totaling & averaging a spreadsheet

[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?

 

[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: (e-mail address removed)



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

ROCK ON!,

Scott

 

[Pecoflyer]

At first sight, a Pivot Table could be a solution