Formula for Countifs including a date range
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!
Best Answer
-
Try this...
=COUNTIFS([Date of Meeting]:[Date of Meeting], AND(@cell >= DATE(2021,01,01),@cell <= DATE(2021,03,31), [Contact]:[Contact], ="Rebecca Robinson")
Answers
-
Try this...
=COUNTIFS([Date of Meeting]:[Date of Meeting], AND(@cell >= DATE(2021,01,01),@cell <= DATE(2021,03,31), [Contact]:[Contact], ="Rebecca Robinson")
-
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.
-
Sorry about that. Those things can be a little pesky at times. Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!