totaling & averaging a spreadsheet
 

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?
--
Thanks,
Sharon

totaling & averaging a spreadsheet
 

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:



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

ROCK ON!,

Scott


"SHARON" wrote:

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?
--
Thanks,
Sharon

totaling & averaging a spreadsheet
 

At first sight, a Pivot Table could be a solution


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=32704