RussChilds
Active Member
- Joined
- Jun 8, 2007
- Messages
- 267
Hi,
I'm trying to count GCSE results. I want to count if a pupil has 5 GCSEs (A* - C grades) including Maths & English. Maths is P2 and English is V2.
I'm trying the below formula but it won't work. Can you help?
=IF(AND(OR(P2={"A*","A","B","C"}),OR(V2={"A*","A","B","C"})),IF(SUM(COUNTIF(P2,V2,AB2,AI2,AN2,AT2,AZ2,BF2,BL2,BR2,BX2,CD2,CJ2,CP2,CV2,DB2,DH2,DN2,DT2,DZ2,EF2,EL2,{"A*","A","B","C"}))>=5,"Yes","No"),"No")
Many thanks,
Russ
I'm trying to count GCSE results. I want to count if a pupil has 5 GCSEs (A* - C grades) including Maths & English. Maths is P2 and English is V2.
I'm trying the below formula but it won't work. Can you help?
=IF(AND(OR(P2={"A*","A","B","C"}),OR(V2={"A*","A","B","C"})),IF(SUM(COUNTIF(P2,V2,AB2,AI2,AN2,AT2,AZ2,BF2,BL2,BR2,BX2,CD2,CJ2,CP2,CV2,DB2,DH2,DN2,DT2,DZ2,EF2,EL2,{"A*","A","B","C"}))>=5,"Yes","No"),"No")
Many thanks,
Russ