COUNTIF(S) date range

Neree Jackson

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?

Paul Newcome

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 Newcome

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)

Neree Jackson

Paul - thank you so much!

Paul Newcome

Happy to help. 👍️