COUNTIFS criteria including dates after X
I'm trying to create a formula that counts the number of entries submitted to a separate sheet per person completed since a specific date (3/24/2020).
My formula that works for counting all entries by individual is =COUNTIF({Other Sheet Range1}, [Member Name]1) but when I try adding the AND {Other Sheet Range2} //Submission Date// is on or after 3/24 I get issues.
Pardon the strange way of entering the formula, was having issues the the 'greater than' & 'equal to' symbols.
Best Answer
-
You'll need to use COUNTIFS so you can have multiple criteria.
Something like this:
=COUNTIFS({Other Sheet Range1}, [Member Name]1, {Other Sheet Date Range}, DATE(2020, 3, 24))
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
You'll need to use COUNTIFS so you can have multiple criteria.
Something like this:
=COUNTIFS({Other Sheet Range1}, [Member Name]1, {Other Sheet Date Range}, DATE(2020, 3, 24))
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
=COUNTIFS({Other Sheet Range1}, [Member Name]1, {Other Sheet Range2}, >DATE(2020, 3, 23))
Worked to count all the sessions that happened after 3/23/2020.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 67 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!
