Syntax for formula with a checkbox

Hasan_M

Need help with syntax for a formula for counts.

Goal: Give a count where If STATUS field contains string value "new" and where a checkbox named External is checked.

Formula: =COUNTIFS(Status:Status, "New", [External:External, "T​rue"])

Currently getting an error: #UNPARSEABLE

VBAGuru

Try

=COUNTIFS(Status:Status, "New", External:External, 1)

check boxes are 0 or 1 and brackets should not go around the second statement

VBAGuru

Try

=COUNTIFS(Status:Status, "New", External:External, 1)

check boxes are 0 or 1 and brackets should not go around the second statement

Hasan_M

It worked - Thank You @VBAGuru !!!