Hello, hoping someone can help me rewrite the formula below:
=COUNTIFS({Certification Name-Primary}, "NSE2", {Reviewed&Approved}, true, {At risk check}, true, {Expiring-Expired}, true)
Right now it's only counting if all things are true but what I want is for the count to be limited to if the "at risk check" OR "expiring-expired" is true, not both. I tried to just break up the formula into two columns but ran into the next issue. There are several instances where both "at risk" and "expiring" are checked. Can I get it to not double-count those instances?
Thank you to anyone who can help!
