# Grading score distribution chart and pivot table

#### Grizlore

##### Active Member
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...

### Excel Facts

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