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!

 

[steve the fish]

You can try:

=COUNTIF($A$2:$J$2,"y")/SUM(COUNTIF($A$2:$J$2,{"y","n"}))

then format to percentage

 

[AlanY]

like this?

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K	L
2	y	y	y	y	n	y	n	n	o	o
3
4	y	5
5	n	3
6	y+n	8
7	%y	62.5%
8	%n	37.5%
9
Sheet4

Cell Formulas
Range	Formula
B4	=COUNTIF($A$2:$L$2,A4)
B5	=COUNTIF($A$2:$L$2,A5)
B6	=B4+B5
B7	=B4/$B$6
B8	=B5/$B$6

 

[Aladin Akyurek]

Like this:

=COUNTIFS(A2:L2,"Y")/SUM(COUNTIFS(A2:L2,{"y","n"}))

 

[Tomas4]

It worked, thank you so much guys!