Using Countif with a wide range of data

[wangaa11]

Hello, I am trying to use the countifs fomula to find out the number of times "yes" appears per colour see example below. I would upload an example but for some reason it never lets me.

In this example I want to count the number of times there is a "Yes" with the colour red. The answer should be 7. I have over 20 columns of data and I am wondering if there is a better formula to use outside of =countifs(A1:A7,"Red",B1:B7,"Yes")+countifs(A1:A7,"Red",C1:C7,"Yes")+countifs(A1:A7,"Red",D1:D7,"Yes")+ so on and so on.

Any help is greatly appreciated

	A	B	C	D	E	F	G
1	Red	Yes	No	Yes	Yes	Yes	Yes
2	Blue	No	Yes	N/A	Yes	N/A	No
3	Red	N/A	No	N/A	Yes	N/A	No
4	Red	Yes	N/A	No	No	N/A	No
5	Green	Yes	N/A	No	No	N/A	N/A
6	Green	Yes	N/A	No	No	N/A	N/A
7	Blue	N/A	No	Yes	No	No	N/A

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I	J
1	A	B	C	D	E	F	G
2	Red	Yes	No	Yes	Yes	Yes	Yes		Red	7
3	Blue	No	Yes	N/A	Yes	N/A	No		Blue	3
4	Red	N/A	No	N/A	Yes	N/A	No		Green	2
5	Red	Yes	N/A	No	No	N/A	No
6	Green	Yes	N/A	No	No	N/A	N/A
7	Green	Yes	N/A	No	No	N/A	N/A
8	Blue	N/A	No	Yes	No	No	N/A
List

Cell Formulas
Range	Formula
J2:J4	J2	=SUMPRODUCT(($A$2:$A$8=I2)*($B$2:$G$8="Yes"))

 

[wangaa11]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I	J
1	A	B	C	D	E	F	G
2	Red	Yes	No	Yes	Yes	Yes	Yes		Red	7
3	Blue	No	Yes	N/A	Yes	N/A	No		Blue	3
4	Red	N/A	No	N/A	Yes	N/A	No		Green	2
5	Red	Yes	N/A	No	No	N/A	No
6	Green	Yes	N/A	No	No	N/A	N/A
7	Green	Yes	N/A	No	No	N/A	N/A
8	Blue	N/A	No	Yes	No	No	N/A
List

Cell Formulas
Range	Formula
J2:J4	J2	=SUMPRODUCT(($A$2:$A$8=I2)*($B$2:$G$8="Yes"))

That is worked thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.