Using CountIFS and DISTINCT formula
I am trying the below formulas:
=COUNTIFS(DISTINCT({Customer Name}, {Sales Rep}, Ecosystem@row, {ERP}, "Oracle Cloud"))
=COUNTIFS(DISTINCT({Customer Name}, {Sales Rep}, Ecosystem@row, {ERP} ="Oracle Cloud"))
Error message is: #Incorrect Argument
I am trying to COUNT the customer names IF the sales rep on the reference matches the sales rep in my row, and IF the the ERP in the reference is Oracle Cloud...
I also know that there are duplicates / multiple lines for each customer and only want to count DISTINCT customer names (count 1 per customer)...
What is wrong with my formula / how would I fix my formula?
Answers
-
You need a COUNT/DISTINCT/COLLECT combo. The DISTINCT function does not allow for anything other than a range (which is provided by the COLLECT function).
=COUNT(DISTINCT(COLLECT({Customer Name}, {Sales Rep}, @cell = Ecosystem@row, {ERP}, @cell = "Oracle Cloud")))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!