Forum Discussion
COUNTIFS WITH 3 CRITERIA
I want to count the number of "training" for Elter Wilson on 3/6/24. What would the COUNTIF statement look like?
=COUNTIFS([TRAINING/QA], "TRAINING", [DATE], DATE(2024, 3, 6), [REPRESENTATIVE], "Elter Wilson")
and
=COUNTIFS([TRAINING/QA], "TRAINING", [DATE], DATE(2024, 3, 6), [REPRESENTATIVE], "Elter Wilson", [RESULTS], "PASS")
Remark: I have assumed that the DATE column contains real dates. If they are text values, use "3/6/24" instead of DATE(2024, 6, 3).
Thank you!
I forgot to include the table name. If it is Table1:
=COUNTIFS(Table1[TRAINING/QA], "TRAINING", Table1[DATE], DATE(2024, 3, 6), Table1[REPRESENTATIVE], "Elter Wilson")
and
=COUNTIFS(Table1[TRAINING/QA], "TRAINING", Table1[DATE], DATE(2024, 3, 6), Table1[REPRESENTATIVE], "Elter Wilson", Table1[RESULTS], "PASS")