How to implement an Average If Formula


Hello all,

I am looking to have a cell in the SOV Comp% column be averaged from every cell in the % Complete column based upon a label from a drop menu in the SOV Category column.

Any assistance would be greatly appreciated. Please see image below for reference.


  • Sing C
    Sing C ✭✭✭✭✭✭

    Hi @robert.hallstrom,

    Looking at your screenshot I'm assuming that, for example, in row 6 (Lighting), in the SOV Comp% column, you want to average the %complete column of every row where the SOV category column = Lighting. If so, give this a try, you can convert it to a column formula.

    =AVERAGEIF([SOV Category]:[SOV Category], [Task Name]@row, [% Complete]:[% Complete])

    Hope that helps. Let me know if that answers your question.


    Sing Chen

    Process Architect, Ceridian


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!