Count Distinct Rows Using AND and OR
Hi geniuses. I need help with a formula. I have a sheet that looks like this:
I need to get a count of distinct rows that are Type = Task AND have (Past Due = 1 OR Jeopardy Status = Red). I assume I'll need to use COUNTIFS with OR and DISTINCT, but I'm not sure how to structure it. Thoughts? Thank you very much.
Help Article Resources
Check out the Formula Handbook template!