I am trying to write a formula which will count the value "Yes" in columns I:I to M:M. However, the value "Yes" should not be counted more than once on the same row.
Ex.
Column I:I Column J:J
Yes Yes
No Yes
No No
Total unique "Yes" = 2
Can someone help please?
Ex.
Column I:I Column J:J
Yes Yes
No Yes
No No
Total unique "Yes" = 2
Can someone help please?