Hopefully Im explaining this clear enough, I apologize if not.
Im trying to count the number of times "Patrick Corbin" appears in a column (on sheet 'Games') AND the result of cells BK minus BR are less than 0 (BK-BR<0).
Heres the formula I tried but getting a value error result:
=COUNTIFS(Games!BF:BF,"Patrick Corbin",Games!BF:BR,Games!BK:BK-Games!BR:BR<0)
Im trying to count the number of times "Patrick Corbin" appears in a column (on sheet 'Games') AND the result of cells BK minus BR are less than 0 (BK-BR<0).
Heres the formula I tried but getting a value error result:
=COUNTIFS(Games!BF:BF,"Patrick Corbin",Games!BF:BR,Games!BK:BK-Games!BR:BR<0)
