Percentage Inaccurate for Simple Calculation
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)))
Best Answer

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
Answers

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

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

Help Article Resources
Categories
Check out the Formula Handbook template!