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))
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. 😀
Thank you,
Hector Arriaran
Customer Care Specialist
Vanderbilt University Medical Center
Best Answer
-
You need "range comma criteria comma range comma criteria comma", so on and so forth making sure to put commas between each piece.
Answers
-
You would include the date range/criteria sets using the same syntax in your first COUNTIFS.
-
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))
Thank you,
Hector Arriaran
Customer Care Specialist
Vanderbilt University Medical Center
-
I may have figured it out,
=COUNTIFS({Divisions}, Division@row, {Request Entered Date}, >=DATE(2023, 8, 1) <= DATE(2023, 8, 31))
Thank you,
Hector Arriaran
Customer Care Specialist
Vanderbilt University Medical Center
-
You need "range comma criteria comma range comma criteria comma", so on and so forth making sure to put commas between each piece.
-
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.
Thank you,
Hector Arriaran
Customer Care Specialist
Vanderbilt University Medical Center
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!