Using countifs with a criteria to count distinct values
I am trying to count the number distinct values with status colors that are red, yellow, or green. We have the same property IDs with multiple line items. Therefore, I am trying to count multiple property IDs as one distinct value if they have a status of red, yellow, or green.
The logic would be count distinct values (property IDs) if the status if xxx.
Help Article Resources
Check out the Formula Handbook template!