COUNTIFS WITH 3 CRITERIA

[Jennifer_Gray]

I want to count the number of "training" for Elter Wilson on 3/6/24.  What would the COUNTIF statement look like?

[#2]

Also, how would I add a 4th criteria of Pass?

[#3]

@Jennifer_Gray 

=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).

[#4]

Thank you!

[#5]

@Jennifer_Gray 

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