COUNTIFS with Multiple Criteria and Dates

I am trying to figure out how many of the cells contain certain practice locations on a certain date. For instance I was to know the amount of orders from BWMG Adult and Senior Care, BWMG Hanover, BWMG Pasadena, BWMG Primary Care North, BWMG Shipley, on 01/05/2024, I have tried various formats for the formula and cannot get it to work, this is what I have currently, however it is not returning the correct number.

=COUNTIFS({THMD CareKit Referral Form_Master Range 1}, "BWMG Adult and Senior Care") + COUNTIFS({THMD CareKit Referral Form_Master Range 1}, "BWMG Hanover") + COUNTIFS({THMD CareKit Referral Form_Master Range 1}, "BWMG Pasadena") + COUNTIFS({THMD CareKit Referral Form_Master Range 1}, "BWMG Primary Care North") + COUNTIFS({THMD CareKit Referral Form_Master Range 1}, "BWMG Shipley") + (COUNTIFS({THMD CareKit Referral Form_Master Range 2}, "2024, 01, 05"))


Source Sheet:

Data Sheet, should be returning 1 for each cell but the numbers aren't correct...



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!