Countif a value is within a range of Owner Names
=COUNTIFS(Owner:Owner, INDEX({eRNP team Range 1}, MATCH(Owner:Owner, {eRNP team Range 1}, 0)), Status:Status, "5. Closed - not")
Answers
-
@Psaul Henry Could you share some screenshots and a detailed description of exactly what you are counting based on what? I think I can offer a resolution but I need more details. It is hard to help without a visual reference and a good understanding of your end goal. You can make a copy of the sheets and scrub the data before screenshoting. Thanks!
Melissa Boehl
Smartsheet Architect | TurningPoint Energy
-
Apologies for the late reply.
I want to find the total number of individuals from a range of Owner names with the status 1. New.
The formula is below.
=COUNTIFS(Owner:Owner, {New Sheet Range 1}, Status:Status, "1. New")
The problem I find is that the '{New Sheet Range 1}' criterion doesn't allow select individual Names from the range of names shown (Names under 'New Sheet').
New Sheet
John, Alfie, Albert, Paul, Don
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!