COUNTIFS with date range as criteria.
I am trying to use the COUNTIFS formula with a date range. Here is what I have:
- 2 sheets
- Attainment sheet (This is where the formula is)
- Schedule sheet
- On the Schedule sheet, I am looking at 2 columns
- Schedule Range 2 = Team column
- Schedule Range 3 = Service Date column
- I am trying to see if the Team column contains a string of text.
- If it does, then count the number of items within a DATE range in the Service Date column.
=COUNTIFS({Schedule Range 2}, CONTAINS("ALBQCC01", @cell), {Schedule Range 3} AND(@cell >= DATE(2021, 02, 01), @cell <= DATE(2021, 02, 07)))
I am getting an #UNPARSEABLE error with the above code.
Thank you,
Best Answer
-
Hi @Justin Mauzy
Hope you are fine, please try the following formula:
=IFERROR(COUNTIFS({Schedule Range 2}, CONTAINS("ALBQCC01", @cell), {Schedule Range 3}, AND(@cell >= DATE(2021, 2, 1), @cell <= DATE(2021, 2, 7))), "")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Justin Mauzy
Hope you are fine, please try the following formula:
=IFERROR(COUNTIFS({Schedule Range 2}, CONTAINS("ALBQCC01", @cell), {Schedule Range 3}, AND(@cell >= DATE(2021, 2, 1), @cell <= DATE(2021, 2, 7))), "")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
That worked perfectly! Thank you for the quick response.
-
Excellent, I will be happy to help you any time
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!