How can I count the number of incoming calls per month using the "=countif" formula
I've had a chance to look around and found some information on being able to count the number of calls for a given month. However I'm stuck as the formula I'm entering is not working, stating it's an incorrect argument.
Here is the formula. =COUNTIF({Call Flow Tracking Range 1}, >=DATE(2021, 8, 1), {Call Flow Tracking Range 1}, <=DATE(2021, 8, 31)) + ""
- I've tried to switch < & = signs around, which resulted in #UNPARSEABLE.
- Then, taking out all of the spaces, which resulted in #INCORRECT ARGUMENT.
- I tried adding " " around arguments, which resulted in #UNPARSEABLE.
I'm referencing the date Column in "Call Flow Tracking" which is range 1 (below)
What am I missing? The return value (call total) should be 84 for Aug21, 235 for Sep21, and 150 for Oct21.
Best Answer
-
Smartsheet answered me. This works, Yeah!
=COUNTIFS({Call Flow Tracking Range 1}, >= DATE(2021, 8, 1), {Call Flow Tracking Range 1}, <= DATE(2021, 8, 31))
Answers
-
Smartsheet answered me. This works, Yeah!
=COUNTIFS({Call Flow Tracking Range 1}, >= DATE(2021, 8, 1), {Call Flow Tracking Range 1}, <= DATE(2021, 8, 31))
-
Wonderful! I'm glad you were able to find a solution.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!