Can anyone help with a formula to count distinct entries that are not "N/A"?

mlandine · 04/27/20

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.

Paul Newcome · 04/27/20

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")

Paul Newcome · 04/27/20

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")

mlandine · 04/27/20

That worked, thank you very much!

Paul Newcome · 04/27/20

Happy to help! 👍️

Best Answer