COUNTIFS with AND OR in row

jgryniewicz

Hi, I am trying to count child rows ONCE where 'not applicable' is false AND either the 'override' is true OR the 'change default' is true. If both are true do not count twice. AI gave me the below formula but it is adding both true columns.

=COUNTIFS([Counter Helper]:[Counter Helper], @cell = "Account", [Change Enforcement Default]:[Change Enforcement Default], 1, [Not Applicable]:[Not Applicable], 0) + COUNTIFS([Override Policy (if available)]:[Override Policy (if available)], 1, [Not Applicable]:[Not Applicable], 0)

Paul Newcome

That's a good start. Now you just need to subtract a 3rd COUNTIFS that counts where both are true. The basic idea is

=COUNTIFS(first is true) + COUNTIFS(second is true) - COUNTIFS(both are true)