=IF(AND(B4>0,B4<7,C4>0,C4<7,D4>0,D4<7,E4>0,E4<7),SUM(IF(COUNTIF(B$1:E$1,"="&B$1)>=COUNTIF(B4:E4,"="&B$1),COUNTIF(B4:E4,"="&B$1,IF(COUNTIF(B4:E4,"="&B$1)>0,COUNTIF(B$1:E$1,"="&B$1),0)),IF(
AND(COUNTIF(B$1:E$1,"="&C$1)>=COUNTIF(B4:E4,"="&C$1),B$1<>C$1),COUNTIF(B4:E4,"="&C$1),IF(AND(COUNTIF(B4:E4,"="&C$1)>0,B$1<>C$1,COUNTIF(B$1:E$1,"="&C$1),0)),IF(AND(COUNTIF(B$1:E$1,"="&
D$1)>=COUNTIF(B4:E4,"="&E$1),B$1<>D$1,C$1<>D$1),COUNTIF(B4:E4,"="&D$1),IF(AND(COUNTIF(B4:E4,"="&D$1)>0,B$1<>D$1,C$1<>D$1),COUNTIF(B$1:E$1,"="&D$1),0)),IF(AND(COUNTIF(B$1:E$1,"="&E$1)
>=COUNTIF(B4:E4,"="&E$1),B$1<>E$1,C$1<>E$1,D$1<>E$1),COUNTIF(84:E4,="&E$1),IF(AND(COUNTIF(B4:E4,"="&E$1)>0,B$1<>E$1,C$1<>E$1,D$1<>E$1),COUNTIF(B$1:E$1,"="&E$1),0)))&"correct,"&





SUMPRODUCT(--(B4:E4==B$1:E$1))&"in the right position","")


B$1:E$1,"="&D$1),0)),IF(AND(COUNTIF(B$1:E$1,"="&D$1),0)),IF



(B4:E4,"="&D$1),IF(AND(COUNTIF(B4:E4,"="&D$1)>0,B$1<>D$1),




COUNTIF(B$1:E$1,"="&D$1),0)),IF(AND(COUNTIF(B$1:E$1








>=COUNTIF(B4:E4,"="&B$1),COUNTIF(B4:E4,"="&B$1),COUNTIF(B4:E4,"="&B$1),IF(COUNTIF(B4:E4,"="&B$1>0, COUNTIF(








































https://www.youtube.com/watch?v=SIANz335RcU
time: 2:32
time: 5:49