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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!