I need to have the formula look from B2:Z2 and if there is a value, sum that
and then divide by the number of cells containing a value to achieve an
average.

Any suggestions