Counting Unique Data Only if Associated Column is Not Blank
Hello again! We really do research these things before we ask! ;)
We are looking to count the unique Store Numbers for "P1 Complete Dates" and "P2 Complete Dates" in the Sheet's Summary Data, so we can make sure each store is only being counted once for each phase.
The formula that we found and tried is only giving a result of 1, which we know is inaccurate.
=COUNT(DISTINCT(COLLECT([Store Helper]:[Store Helper], [P1 Complete Date]:[P1 Complete Date]), <>""))
Thanks for taking a look!
Help Article Resources
Check out the Formula Handbook template!