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
-
=([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))
Answers
-
=([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))
-
thank you!!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!