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

Elizabeth Aird

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!!

L_123

=([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))

L_123

=([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))

Elizabeth Aird

thank you!!