I'm trying to find the number of cells that meet a criterion within a specific date window.

=COUNTIFS({Access Request Range 5},>=(2021, 7,1),{Access Request Range 5}, <=(2021,9,30), {Access Request Range 2},"Approved")

Find more posts tagged with

Accepted answers

Maxwony

I found it. there was a ")" missing.

=COUNTIFS({Access Request Range 5}, AND(@cell >= DATE(2021, 7, 1), @cell <= DATE(2021, 9, 30)), {Access Request Range 2}, "Approved")

All comments

Jason Duryea

Try this...

=COUNTIFS({Access Request Range 5}, AND(@cell >= DATE(2021, 7, 1), @cell <= DATE(2021, 9, 30), {Access Request Range 2}, "Approved")

Maxwony

I now have an error for the data type

I'm referencing a separate sheet. Trying to get a count of the statuses marked "Approved" within the 3rd quarter of the year based on their date submitted (7/01/2021 to 9/30/2021)

Maxwony

I found it. there was a ")" missing.

=COUNTIFS({Access Request Range 5}, AND(@cell >= DATE(2021, 7, 1), @cell <= DATE(2021, 9, 30)), {Access Request Range 2}, "Approved")

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.