Hi

=AVERAGE(B2:Z2)


Arvi Laanemets


"LostNFound" wrote in message
...
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