The Rookie can't wrap her mind around it...

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

Every year I must submit a fifty question evalution to my
colleagues. They judge my work performance.

They score me 1-5 (weak to outstanding) or X (N/A)

I have to tally them to a summary sheet.

The summary sheet looks just like the survey except after
each question I must put a number in the total box under
1, then 2, then 3, etc. to total the scores.

Committed to serving the company 1 2 3 4 5 X
___ ___ ___ ___ __ __
Committed to the corporate vision...

I use Excel at work and I'm staring at these thinking
there must be a way to tally these with a spreadsheet
instead of doing it by hand.

Am I nuts?

Thanks!
 
It depends. If they give you the evaluation to fill out on paper, then
you will still have to enter the scores into excel to formulate it.

However if they give you the evaluation in Excel form, you could whack
in a simple formula to tally the score as you go.

Alernatively, you could get creative with the spreadsheet, and generate
random numbers between 1 - 5 to go into the fields so that you didn't
actually have to do any work.

Hope this helps,

tehwa
 
Hi Denise

With your values 1,2,3,4,5,X in cells B1:G1 and
Question names in Cells A2:A51

Enter anything in cells B2:G51 to represent a selection e.g. an "x"
In cell B52 enter
=COUNTIF(B2:B51,"<>")
Copy across through cells C52:G52 and you will have a count of the number of
each value that has been recorded.

If you had a sheet for each colleague in your workbook plus an extra sheet
for your overall summary then ther formula needed for the summary would be
='Sheet1:Sheet50'!B52
copied across the sheet to pick up the totals of all responses.
 
Back
Top