Formula for Countifs including a date range

Options
✭✭

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!

• ✭✭✭✭✭✭
Options

Try this...

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

• ✭✭✭✭✭✭
Options

Try this...

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

• ✭✭
Options

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.

• ✭✭✭✭✭✭
Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!