Can anyone help with a formula to count distinct entries that are not "N/A"?
So far I have been able to count distinct but have not been successful in excluding the "N/A" value. Any help is greatly appreciated.
Tags:
Best Answer
-
What is your current formula?
You are probably going to end up with something along the lines of...
=COUNT(DISTINCT(COLLECT({Range to Count}, {Range that has exclusions}, @cell <> "N/A")
Answers
-
What is your current formula?
You are probably going to end up with something along the lines of...
=COUNT(DISTINCT(COLLECT({Range to Count}, {Range that has exclusions}, @cell <> "N/A")
-
That worked, thank you very much!
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!