SOLVED
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")
