Forum Discussion
JCox7
Oct 10, 2023Copper Contributor
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")
1 Reply
- Detlef_LewinSilver Contributor