COUNTIFS that tests if one cell minus another cell (in a different column) is <0

[Nandy7071]

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)

 

[Joe4]

Welcome to the Board!

Try this:

[COLOR=#333333]=SUMPRODUCT(--(Games!BF:BF="Patrick Corbin"),--(Games!BR:BR>Games!BK:BK))[/COLOR][COLOR=#333333]<games!bk:bk-games!br:br))< font="">

</games!bk:bk-games!br:br))<>[/COLOR]

 

[Nandy7071]

Works perfectly. Thanks for the solution and quick response Joe

 

[Joe4]

You are welcome.
Glad I was able to help!