Formula for Countifs including a date range

JH@HL

Hi, I'm trying to calculate the number of meetings in a time range for an employee named Rebecca. The sheet is a list of all employee meetings over 2021 as a whole. First column the employee name, then the date of the meeting. I'm trying to count the number of meetings for employees for each quarter.

Time frame = first quarter 2021

1st Column Name = Contact (name of the employee - a smartsheet contact column)

2nd Column Name = Date of Meeting (a smartsheet date column)

Here is the formula I am using.

=COUNTIFS([Date of Meeting]:[Date of Meeting], &>=DATE(2021,01,01),<=DATE(2021,03,31), [Contact]:[Contact], ="Rebecca Robinson"]. I keep getting unparseable, and I am having a lot of trouble. Keep trying it different ways. I seem to get a good result for 1 meeting date, but when i try to expand to a date range, i can't get it.

Thanks if you think you can help!

Paul Newcome

Try this...

=COUNTIFS([Date of Meeting]:[Date of Meeting], AND(@cell >= DATE(2021,01,01),@cell <= DATE(2021,03,31), [Contact]:[Contact], ="Rebecca Robinson")

Paul Newcome

Try this...

=COUNTIFS([Date of Meeting]:[Date of Meeting], AND(@cell >= DATE(2021,01,01),@cell <= DATE(2021,03,31), [Contact]:[Contact], ="Rebecca Robinson")

JH@HL

YES! Phew - thank you so much - what a relief! I had to add an extra end parenthesis after the second date, but now it works. You made my day, Paul. Thank you.

Paul Newcome

Sorry about that. Those things can be a little pesky at times. Happy to help. 👍️