COUNTIF [criteria] + give %

[Tomas4]

Hi guys,



Was trying to crack this one up, got nothing but a head buzzing by now...


A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2
y y y y n y n n o o




What would be a formula to calculate % for:


Count ONLY if A2:L2 is 'y' AND 'n', ignoring anything else (blank or 'o')


Then give me a % for how many correct answers ('y') vs incorrect answers ('n')




So in this example it would be:


Total Count: 8 (5 x 'y' & 3 x 'n')
% Correct: 63%


Any suggestions?


Thank you!

[gebobs]

=countif(A2:L2,"y")/(countif(A2:L2,"n")+(countif(A2:L2,"y"))

[Tomas4]

Thank you!!