# 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)))

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

• 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))

• I may have figured it out,

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

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

• Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!