Percentage Inaccurate for Simple Calculation

Deena Duran

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)))

Paul McGuinness

Hi @Deena Duran

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

Paul McGuinness

Hi @Deena Duran

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

Deena Duran

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

Paul McGuinness

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

Thanks

Paul