Forum Discussion

JCox7's avatar
JCox7
Copper Contributor
Oct 10, 2023
Solved

Error with Countifs

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.

 

=COUNTIFS(T6:T12,"Win",S6:S12,"Red")

 

 

 

Resources