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
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 |