Calculate percentage on multiple columns in 1 cell

[Louis1983]

Hi

Please can you assist me, I need to work out a total percentage "Yes" in the below colums. If I use the countif formula it only works on 1 column (B) but it needs to calculate column B + D + F.

Column A	Column B	Column C	Column D	Column E	Column F
Updated schedule	Yes	correctly	NO
Comprehensively	NO
breakdown schedule	NO
B/D per km <tbody> </tbody>	NO	correctly	NO	hit rate	NO
Total Percentage

<tbody>
</tbody>

Yes /NO

<tbody>
</tbody>

 

[vmjan02]

Try this.

=(COUNTIF(B2:B6,"Yes")+COUNTIF(D2:D6,"Yes")+COUNTIF(F2:F6,"Yes"))/(COUNTA(B2:B6)+COUNTA(D2:D6)+COUNTA(F2:F6))

you can change the range

 

[magpie2000k]

=COUNTIF(C3:C6,"Yes")/COUNTA(C3:C6)

should work

too late

 

[Louis1983]

Thank you, it seems to work correctly now.

 

[jtakw]

Hi,

Maybe this:

Book1
	A	B	C	D	E	F
1	Updated schedule	Yes	correctly	NO
2	Comprehensively	NO
3	breakdown schedule	NO
4	B/D per km	NO	correctly	NO	hit rate	NO
5
6
7	Total Percentage
8
9	Yes /NO	16.67%
Sheet74

Cell Formulas
Range	Formula
B9	=COUNTIF(B1:F4,"Yes")/COUNTIF(B1:F4,"No")

B9 formatted as "percentage"