Adding 5 values and dividing does not work

Hi all ! Help!

I am trying to add these 5 cells and then divide by 5. But I get this odd number 4.2??


Please note the H/L columns also has a formula

The COLOR(A-E) columns has a conditional formula to turn red/green

Thank you!

Answers

  • Hey @Robert K

    Right now you are adding the first three cells together (using these parentheses) to keep the values together, then adding 4 and 5 separately, and then dividing by 5. This means that only [5th Patient H/L]@row is being divided by 5 instead of the total.

    =(1 + 2 + 3) + 4 + 5 / 5

    You'll want to structure your formula like this:

    =(1 + 2 + 3 + 4 + 5) / 5

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!