Count or Sum formula

I want to sum the columns that contain 1 and have tried a SUMIF and COUNTIF Formula, as well as using the AI formula generator within the sheet - nothing is working. As you will see from the screen shot below I would be expecting this column to return a value of 7 but, it just returns 0.

I know it's going to be something really stupid / simple but, I just can't work out the issue.

TIA

Cheryl

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Did you make that update removing the quotes in all of the columns being referenced?

All comments

Paul Newcome

How exactly are you populating the ones and zeros?

Cheryl C

Hi Paul

They are being populated via a formula - see example below:

Many thanks

Cheryl

Paul Newcome

Try removing the quotes from around the one and zero.

Cheryl C

Hi Paul

No, that's still returning a 0

Paul Newcome

Did you make that update removing the quotes in all of the columns being referenced?

Cheryl C

Thats cracked it! Knew it was going to be something super simple. Thanks

Paul Newcome

Happy to help. 👍️

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.