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



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

ROCK ON!,

Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calcaulate # of days worked 2
excel and word 1
Averaging the two most recent entries in a column 13
Counting occurances 8
Need loop structure to get round limited IF statements 5
Splitting hours for payroll purposes 4
Absence Tracking Spreadsheet 1
Comparing Two Spreadsheets 4

Top