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

Options

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!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!