Error with Countifs

Copper Contributor

Hi all,


I am struggling to get my formula to count the total of cells with the terms 'Win' if the corresponding cell has the term 'Red'. 


It is only bringing back the value of 1 even if there are multiple occurrences. 


Please see the formula and data below for reference, any help is appreciated.


Thank you.







1 Reply
best response confirmed by JCox7 (Copper Contributor)


Check for additional spaces.