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)
Best Answer
-
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)
Answers
-
Have you tried a COUNTIFS instead?
-
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.
-
How exactly is your percentage ccolumn being populated?
-
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
-
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)
-
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!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!