Not able to count total of different percentage fields?

I'm trying to get a breakdown of how many of each percentage group we received from this quiz and I've tried totaling from a percentage column as well as when the column is set as a decimal and I just keep getting 0 as a total, only the 100% has worked. Not sure if I'm just overthinking it or what, but here are some screenshots and formulas:

=SUMIF([Column40]:[Column40], 0.65)

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

There may be the issue. You are looking for exactly 65%, but the formula populating the percentage may have decimals stored on the back end. My suggestion would be to use a ROUND function on the formula outputting the percentage and have it round to two decimal places.

=ROUND(SUM(………..) / 17, 2)

All comments

Paul Newcome

Have you tried a COUNTIFS instead?

Ashley Klaers

Yeah I've done both SUMIF and COUNTIF just to see if they'd be any different and I'm getting a 0 for both. I've also done "65%" instead of 0.65 and still the same result.

Paul Newcome

How exactly is your percentage ccolumn being populated?

Ashley Klaers

We have a total of 17 questions and I have helper columns so the correct answer populates a 1 and the incorrect populates a 0.

=SUM([Helper1]@row + [Helper 2]@row + [Helper3]@row + [Helper4]@row + [Helper5]@row + [Helper6]@row + [Helper7]@row + [Helper8]@row + [Helper9]@row + [Helper10]@row + [Helper11]@row + [Helper12]@row + [Helper13]@row + [Helper14]@row + [Helper17]@row + [Helper15]@row + [Helper16]@row) / 17

Paul Newcome

=ROUND(SUM(………..) / 17, 2)

Ashley Klaers

That fixed it! I hadn't done a formula for that yet so the ROUND function makes sense. Thanks as always for the help Paul!

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.