Forum Discussion
Solved
COUNTIFS function with multiple criteria
I need help with embedding the COUNTIF function along with the COUNTIFS function. I have two different criteria that I need to count and add together in the first range and then apply a third criter...
=SUM(COUNTIFS(D4:D23,{"A";"B"},E4:E23,"option4"))=SUMPRODUCT(((D4:D23="A")+(D4:D23="B"))*(E4:E23="option4"))You can try these formulas.
I forgot to mention this is for text criteria.