# Percentage Inaccurate for Simple Calculation

Options
✭✭✭✭
edited 06/06/24

Hello all,

I was brought in to help with this formula on another sheet. I took care of the formula, but it doesn't seem to be accurate. They want to calculate the percentage of the one error @row out of the total errors. There 10 total errors right now, which allows for some nice easy math. However, when I calculate 1 out of 10 errors, I am getting 11%, not 10.

What is going on here?

My formula is: =(Counts@row / (COUNT(\$Counts\$1:\$Counts\$9)))

Tags:

• ✭✭✭✭✭✭
Options

Using count in the formula counts non blank cells (including the zeros) not the values of the cells as part of the sum so its actually basing the sum off of 9 rows not 10 events.

Try this instead `=(Counts@row / (SUM(\$Counts\$1:\$Counts\$9)))`

Hope that helps

Thanks

Paul

*Edited for clarity

• ✭✭✭✭✭✭
Options

Using count in the formula counts non blank cells (including the zeros) not the values of the cells as part of the sum so its actually basing the sum off of 9 rows not 10 events.

Try this instead `=(Counts@row / (SUM(\$Counts\$1:\$Counts\$9)))`

Hope that helps

Thanks

Paul

*Edited for clarity

• ✭✭✭✭
Options

Thank you, @Paul McGuinness! That formula worked perfectly! Thank you for the explanation as well. This will help me with future formulas

• ✭✭✭✭✭✭
Options

Hi @Deena Duran not a problem at all always happy to help.

Thanks

Paul

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!