CountIFS Formula between two columns
Greetings,
I'm probably over thinking this but I'm trying to do the following;
I have a customer account number column and an area column.
I would like to count the total number of unique customer account numbers in [Customer Accounts] that appear in area [Areas]
If I have 20 rows of data and 6 of them have a Customer Account Number (unique to the customer) and all 6 of those appear in [Area] then I would like to count all 6.
The Customer ID is the primary key we use across any database we use so it's the more reliable piece of data to count.
is this possible?
Answers
-
How about something like:
COUNT(DISTINCT(COLLECT([Customer Accounts],[Areas],area to count)))
-
I agree with @ron.judenberg112096's solution.
=COUNT(DISTINCT(COLLECT([Customer Accounts]:[Customer Accounts], Areas:Areas, "area to count")))
Were you able to get it to work?
-
I'll check it out now, thanks
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!