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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,099,696
Messages
5,470,207
Members
406,685
Latest member
711excelhelp

This Week's Hot Topics

Top