COUNTIFS with Multiple Criteria and Dates

CaraBart28

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

Paul Newcome

Try this instead:

=COUNTIFS({Location Column}, OR(@cell = "Location A", @cell = "Location B", @cell = "Location C"), {Date Column}, @cell = DATE(2024, 01, 05))

CaraBart28

@Paul Newcome That worked thank you so much!

I am now not able to get it to combine two countif statements when there is only one location in the criteria it needs to look for, what do I need to correct?

I am trying to see how many were ordered on 01/12/2024 for Family Medical Associates

Paul Newcome

You don't use an AND with two COUNTIF functions. You use a COUNTIFS like I did in my last comment.