Count Cells Based upon Criteria – Between Two Dates
Here is my problem:
I have a sheet that has a status of resolved and I want to count the number of resolved issues based upon a specific date range.
I know it is a countifs statement but I'm having issues with the correct format
Any help would be greatly appreciated.
Answers
-
can you screen shot your sheet and post it? will help determine what order I put the countifs in.
-
Due to the nature of the information I can not share the sheet but I'll try and explain better.
Here is what I currently have and it counts the number correctly:
=COUNTIFS({Resolved (July 2020) Range 3}, @cell = $Label$1)
What I need to add is this count but only if it falls between 2 dates from a different column. The column is the creation date and I only want to count if it was resolved between 2 dates.
I hope that helps.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!