I've read the Q&A on these functions but i still can't get mine to work. I'm evaluating two columns: pkg_num, and subprojectorder, then want a count of the Distinct project numbers that meet that criteria
=COUNT(DISTINCT(COLLECT([project_number]1:[project_number]28), [pkg_num]1:[pkg_num]28, ="CD01", subprojectorder1:subprojectorder28,>0)))
So it should return 7
Any advice?!? 😓
Help Article Resources
Check out the Formula Handbook template!