# Not able to count total of different percentage fields?

Options
✭✭✭✭

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)

Tags:

• ✭✭✭✭✭✭
Options

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)

• ✭✭✭✭✭✭
Options

Have you tried a COUNTIFS instead?

• ✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

How exactly is your percentage ccolumn being populated?

• ✭✭✭✭
edited 05/10/24
Options

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

• ✭✭✭✭✭✭
Options

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)

• ✭✭✭✭
Options

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!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!