Can I combine two COUNTIFS formulas if there is a Date Range?

I use this formula to identify how many Requests a certain Division entered.

=COUNTIFS({Divisions}, [Request Entered by]@row, {Request Type}, "Template Request")

I want to combine it with this formula to identify how many times a month, does that certain division enter specific request.

=COUNTIFS({Request Entered Date}, <=(DATE(2023, 8, 31)), {Request Entered Date}, >=(DATE(2023, 8, 1)))

If there is another way to go about this, would love to hear it. 😀

Find more posts tagged with

Accepted answers

Paul Newcome

You need "range comma criteria comma range comma criteria comma", so on and so forth making sure to put commas between each piece.

All comments

Paul Newcome

You would include the date range/criteria sets using the same syntax in your first COUNTIFS.

hjarriaran

Hi @Paul Newcome

I tried combining using the Syntax but getting an error whenever I try adding the second Date Range. Would using the Month and Year be better? I want to isolate the number of requests that it counts to just the month.

=COUNTIFS({Divisions}, [Request Entered by]@row, {Request Entered Date}, <=DATE(2023, 8, 31))

hjarriaran

https://community.smartsheet.com/discussion/comment/395122#Comment_395122

I may have figured it out,

=COUNTIFS({Divisions}, Division@row, {Request Entered Date}, >=DATE(2023, 8, 1) <= DATE(2023, 8, 31))

Paul Newcome

You need "range comma criteria comma range comma criteria comma", so on and so forth making sure to put commas between each piece.

hjarriaran

Thank you @Paul Newcome

=COUNTIFS({Request Type}, "Template Request", {Divisions}, "University Pediatrics", {Request Entered Date}, >=DATE(2024, 4, 1), {Request Entered Date}, <=DATE(2024, 4, 30))

I got it and it's working perfectly.

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.