Combine COUNTIFS with a date and row criterea

I have two formulas working independantly and now I am trying to combine the critera but I am not sure which formula to use.

Working formulas are:

=COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, >=DATE(2020, 1, 1), {ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, <=DATE(2020, 12, 31))

=COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 1}, "A (South king cty)")

Basically I want to look in one row for a criteria (range 2) and then look in another row for a date range (range 1).

Maybe: =COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 1}, "D (north seattle/king cty)", AND(COUNTIF({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, >=DATE(2020, 1, 1), {ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, <=DATE(2020, 12, 31))))

Help!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try this:

=COUNTIFS({ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 1}, "A (South king cty)", {ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, >=DATE(2020, 1, 1), {ARCHIVE of SEATTLE METRO AREA TRUCK SCHEDU Range 2}, <=DATE(2020, 12, 31))

Jared F

Thanks Paul! I had a corworker help me with my issue, I had a range selected instead of a row when I first wrote the formual (first section) so when combining them it did't work. Thanks for the response!

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.