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
Check out the Formula Handbook template!