Formula doublecounting
Hello, hoping someone can help me rewrite the formula below:
=COUNTIFS({Certification NamePrimary}, "NSE2", {Reviewed&Approved}, true, {At risk check}, true, {ExpiringExpired}, 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 "expiringexpired" 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 doublecount those instances?
Thank you to anyone who can help!
Answers

I think you would just need to expand the formula to count each value separately, then subtract them together. So something like:
=COUNTIFS({Certification NamePrimary}, "NSE2", {Reviewed&Approved}, true, {At risk check}, true) +
COUNTIFS({Certification NamePrimary}, "NSE2", {Reviewed&Approved}, true, {ExpiringExpired}, true) 
COUNTIFS({Certification NamePrimary}, "NSE2", {Reviewed&Approved}, true, {At risk check}, true, {ExpiringExpired}, true)
So the first two parts will calculate the individual check boxes, then the third part would subtract the instances where they are both checked.
Jason Tarpinian  Sevan Technology
Smartsheet Aligned Partner
Help Article Resources
Categories
Check out the Formula Handbook template!