Average if - to be correct if one of the cells is blank


I am trying to average, correctly, 3 separate cells across a row. If one or more of the cells is blank, it is not averaging correctly.

I know I need to somehow include if it's greater than 0, but can't seem to work it out.

Always tweaking things at the beginning of the year :) Thanks!!

Best Answer

  • L_123
    L_123 ✭✭✭✭✭✭
    Answer ✓

    =([car scores]@row+[quality alerts % on time]@row+[action items % closed on time]@row)/(if(isblank([car scores]@row),0,1)+if(isblank([quality alerts % on time]@row),0,1)+if(isblank([action items % closed on time]@row))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!