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 :)

Find more posts tagged with

Formulas

Accepted answers

Heather Duff

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

Global Engagement

Thank you!

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

All comments

Heather Duff

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

Global Engagement

Thank you!

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.