Cross Sheet Distinct Count Formula
I'm trying to count distinct values in a different sheet using a cross sheet formula. More specifically, I have parent/child rows, and I only want to count the parent rows. The child rows have duplicate values in the column that I'm counting, which makes me think that something like countif(distinct(something...) will work. Or am I better off using something along the lines of Countif(Descendants=0) or something like that?
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!