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

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.