Step 7  Repeat the Steps from 6 in Row 12 but use (B3:B11)

Step 7a     Select Cell B12 that has the Error Message.

Step 7b     Edit the Average Formula so that it looks like the "If Error Formula" below:     

Step 7c   Use the "skinny plus +" to extend the NEW Formula all the way to the left of the row.

Select Cell B12 > Move your mouse around until it changes to a "skinny plus." >
Click > Hold >Drag to the left >until you reach J12 > Release.