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
Check out the Formula Handbook template!