COUNTIF(S) date range
I know I've seen several questions regarding counting within a date range, but I can't find something that covers this problem. I can get a COUNTIF to work with each half of this formula (Range, Criteria), but I can't get them to work together. I am trying to count several recurring instances of an event. They are filled into the sheet via a form, and I want to count all that occur in each month and record them in rows of deliverables (how many in each of May, June, July, etc)
=COUNTIFS(CHILDREN([Date Start]50), >=([Date Start]3), [CHILDREN([Date Start]50), <=([Date End]3)])
I get #Unparseable as my error message
=COUNTIF(CHILDREN([Date Start]50), >=([Date Start]3)) works perfectly & =COUNTIF(CHILDREN([Date Start]50), <=([Date End]3)) works perfectly.
Any ideas?
Best Answer
-
Your parenthesis and square brackets just need a little adjusting.
=COUNTIFS(CHILDREN([Date Start]50), >=[Date Start]3, CHILDREN([Date Start]50), <=[Date End]3)
Answers
-
Your parenthesis and square brackets just need a little adjusting.
=COUNTIFS(CHILDREN([Date Start]50), >=[Date Start]3, CHILDREN([Date Start]50), <=[Date End]3)
-
Paul - thank you so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!