Grading score distribution chart and pivot table

Grizlore

Active Member
Joined
Aug 22, 2006
Messages
257
Hi All,

Any help greatly appreciated...

I am trying to produce a distribution chart (bell curve) of my company's employee grades

Each employee achieves a numerical score, which results in a final grade (U, M, F-, F, F+, E, S)

I am using this formula to set the achieved grade...

=IF(AK9=meets,"U",IF(AK9=fullminus,"M",IF(AK9=full,"F-",IF(AK9=fullplus,"F",IF(AK9=exceeds,"F+",IF(AK9=Significant,"E","S"))))))

(all the ='s in the above formula are in fact lessthan signs, but it doesnt seem to wanna show them, so I have chaged them)

Then on another sheet I am counting those grade with this formula and producing a distribution chart (bell curve)

=COUNTIF('Scores'!$AL$9:$AL$997,B$1)

This all works, however I need to compare grades by the location of the employee, which is in column C.

I dont think I can do this in a pivot table (but would like to)

So, how can I count all those by location?

Is there a nested COUNTIF function I can use and if so... can anyone suggest a solution please?

Any help greatly appreciated...
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,095,722
Messages
5,446,140
Members
405,383
Latest member
mccordscvs

This Week's Hot Topics

Top