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