Counting checked boxes

Global Engagement · 12/15/21

Good morning (afternoon/evening).

I have looked on the boards and tried to find the answer, but not working for me. I want to count the number of checked boxes in a single column.

I have tried =COUNTIF([(Internal) Proposal Complete]1:[(Internal) Proposal Complete]23), 1)+""

=COUNTIF([(Internal) Proposal Complete]1:[(Internal) Proposal Complete]23), 1)

=COUNTIFS([(Internal) Proposal Complete]1:[(Internal) Proposal Complete]23), 1)

=COUNTIF([(Internal) Proposal Complete]1:[(Internal) Proposal Complete]23), 1)+""

I keep getting '#Unparseable.

Please send help!

Thank you :)

Heather Duff · 12/16/21

It looks like you're having a pesky parenthesis problem (and also using COUNTIFS instead of COUNTIF)! Try this:

=COUNTIF([(Internal) Proposal Complete]1:[(Internal) Proposal Complete]23, 1)

Let me know if it works for you.

Best,

Heather

Global Engagement · 12/16/21

Thank you!

I completely missed that. Really appreciate your help. Thank you

Heather Duff · 12/16/21