Combining Countifs & Distinct Formula
I am trying to combine countifs & distinct formula together but not having any luck. I need to get the count of requirements to 1 workshop (so many to 1). This means there are duplicates which I cannot count. Below is the formula I have tried just not having luck
=COUNTIF(DISTINCT({Business Requirement Document Range 3}){Business Requirement Document Range 1},"MDG_WKSP_04_01-Master Data Process Governance (Initiate) - Profit Center")
Answers
-
You will need to user a COUNT/DISTINCT/COLLECT combo instead.
=COUNT(DISTINCT(COLLECT({Business Requirement Document Range 3}, {Business Requirement Document Range 1},"MDG_WKSP_04_01-Master Data Process Governance (Initiate) - Profit Center")))
Basically we use the COLLECT function to pull together a list of cells from Range 3 based on our Range 1 range/criteria set. Then we wrap it in the DISTINCT function to filter out the duplicates. Then we wrap it in a COUNT function to get the count of what's left.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!