COUNTIF Date Range with criteria


I am trying to count when Brian shows up in column "Auditor Name" but only for a specific week, dating 6/3 - 6/7.

=COUNTIFS({Audit Date}, >=DATE(2024, 6, 3), DATE(2024, 6, 7), AND({Auditor Name}, "Brian Lucas")))

Where is this going wrong?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!