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

hjarriaran · 09/12/23

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

Paul Newcome · 09/13/23

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

Paul Newcome · 09/13/23

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

hjarriaran · 09/13/23

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 · 09/13/23

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 · 09/13/23

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

hjarriaran · 09/14/23

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 · 09/14/23

Happy to help. 👍️

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

Best Answer

Answers

Help Article Resources

Categories