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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!