I have a test area
(the real area is larger but contains the same values: YES, NO)
I want to count in row 50 all YES values but only when there is a YES value in the same column in row 51,
In the small test area shown above, I only want to count the YES in row 50 for column Q, S, V
(The YES in row 50 column T should not be counted)
I tried various combinations of COUNTIF and AND function but could not get the result needed.
I appreciate any hint