Percentage Inaccurate for Simple Calculation

Options
Deena Duran
Deena Duran ✭✭✭✭
edited 06/06/24 in Formulas and Functions

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:

Best Answer

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    edited 06/07/24 Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!