The cells value that contain Not worked, average etc below each persons name are actually genenerated by a formula

=IF((SUM((COUNTIF(B17:B30,0))+(COUNTIF(B17:B30,"n/a"))+((COUNTIF(B17:B30,">=-2")-COUNTIF(B17:B30,">2"))-(COUNTIF(B17:B30,0)))+(COUNTIF(B17:B30,"<-2")+COUNTIF(B17:B30,">2"))))<>14,"NES",IF((COUNTIF(B17:B30,"n/a"))>10,"NES",IF((COUNTIF(B17:B30,0))+(COUNTIF(B17:B30,"n/a"))=14,"PERFECT",IF((COUNTIF(B17:B30,"<-2")+COUNTIF(B17:B30,">2"))>=4,"POOR",IF((COUNTIF(B17:B30,"<-2")+COUNTIF(B17:B30,">2"))=0,"HIGH","AVERAGE")))))

This particlar cell returns "PERFECT" but your formula doesnt recognise it. If i take out the formula and insert PERFECT text it does.