Help with COUNT and DISTINCT function
Hi team - I have a column called Agreement # that has various agreement numbers in them but also many duplicates. I'm trying to get a count of unique numbers but when I combine the COUNT and DISTINCT functions - it keeps coming up with 1.
The Agreement # column looks like this (example):
Is there a problem because there are blanks between the parent row with a number in it?
How would I make the COUNT and DISTINCT funtions to work and disregard blank fields, if that's the problem?
Help Article Resources
Check out the Formula Handbook template!