Need to Sum Multiple Column Check Boxes

I am trying to sum 2 different column's checkboxes and put that number into a different cell. I have tried a bunch of different ways and nothing seems to work.

Below is one variation that I have tried and can't get it to work:

=COUNTIF(AND[Saturday Stay:Saturday Stay] = 1, AND[Sunday Stay:Sunday Stay]=1)

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

https://community.smartsheet.com/discussion/141177/need-to-sum-multiple-column-check-boxes

Hi,

I hope you're well and safe!

Try something like this.

=COUNTIFS([Saturday Stay]:[Saturday Stay], 1) + COUNTIFS([Sunday Stay]:[Sunday Stay], 1)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

All comments

Andrée Starå

https://community.smartsheet.com/discussion/141177/need-to-sum-multiple-column-check-boxes

Hi,

I hope you're well and safe!

Try something like this.

Antonie B

Hi @Angela L ,

You will want to adjust the formula as the formula does not function this way! COUNTIF should be formulates as: =COUNTIF(Range, criterion) → https://help.smartsheet.com/function/countif

Multiple ranges in your example would be =COUNTIFS(Range 1, criterion1, Range 2, criterion 2, etc etc) → https://help.smartsheet.com/function/countifs

Now I am not sure if you need to count the values on rows where this is both true or count seperately and add them together.

If you need both values to be true on the row, it would look like this:

=COUNTIFS([Saturday Stay:Saturday Stay], 1, [Sunday Stay:Sunday Stay], 1)

If you need to count both columns separately and add them together it would be:

=COUNTIFS([Saturday Stay:Saturday Stay], 1) + COUNTIFS([Sunday Stay:Sunday Stay], 1)

I hope this helps?

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.