Count if & Unique Values?
Hi!
I am struggling to figure out the logic required to count the number of monthly/quarterly/bi-annual/annual items without counting duplicates.
Hoping to determine the number of updates on X frequency without counting duplicates. For example, there are 10 different monthly performance emails but they have been updated 10 times (100 performance emails have been produced). Any guidance is appreciated!
My formula is as follows: =COUNTIFS(DISTINCT([item]:[item]), ,[frequency]:[frequency],"monthly")
Best Answer
-
You're almost there, but instead of COUNTIFS, you should use COUNT
=COUNT(DISTINCT(COLLECT([Item]:[Item],[Frequency]:[Frequency], "Monthly")))
Thanks @Sameer Karkhanis for the quick response.
Thanks & Regards
Email ID: info@sspmconsultants.com
Did I answer to your question or fix the problem? Please
help
theSmartsheet Community
by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!
Answers
-
Try this,
=COUNT(DISTINCT(COLLECT([Item]:[Item],[Frequency]:[Frequency], "Monthly")))
-
You're almost there, but instead of COUNTIFS, you should use COUNT
=COUNT(DISTINCT(COLLECT([Item]:[Item],[Frequency]:[Frequency], "Monthly")))
Thanks @Sameer Karkhanis for the quick response.
Thanks & Regards
Email ID: info@sspmconsultants.com
Did I answer to your question or fix the problem? Please
help
theSmartsheet Community
by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!