Counting checked boxes
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 :)
Best Answers
-
Hi @Global Engagement ,
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
-
Thank you!
I completely missed that. Really appreciate your help. Thank you
Answers
-
Hi @Global Engagement ,
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
-
Thank you!
I completely missed that. Really appreciate your help. Thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!