Formula COUNTIFS for checked boa and status NOT "the text"

Question

I have a list, and need count the number of items with checked OFF cell and Decision any but "NOT STARTED"

I tried formula below but got "incorrect argument set".. I tried different wats and lost my hope :)

=COUNTIFS(Complete107:Complete290, =0, NOT(DECISION107:DECISION290, ="NOT STARTED"))

Thank you!

Christine Maurer · Accepted Answer

Hi Olga!

Are you trying to pull in counts for all results that are NOT = "Not Started"?

Try This:

=COUNTIFS(DECISION:DECISION, <>"Not Started", OFF:OFF, true)

Christine

OLGA SMOLENSKAYA · Accepted Answer

Perfect, thank you Christine!