Average Formula

If I am wanting to find the average of wage rates that are referenced on another sheet, how would I create that formula? I have tried several different things and nothing appears to be working.


Best Answer


  • Maria Watters
    Maria Watters ✭✭✭✭✭

    Thank you so much! I was using the wrong one, I needed the =AverageIF formula and it worked.

    THANK YOU and sorry for the limited information I provided. Your response was very helpful!

  • Genevieve P.
    Genevieve P. Employee Admin

    Haha, no worries at all! I'm glad you were able to get it working based on my example above. 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!