dividing a row

LostNFound · Mar 7, 2005

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

Gary Brown · Mar 7, 2005

=Average(B2:Z2)
HTH,
Gary Brown

Arvi Laanemets · Mar 7, 2005

Hi

=AVERAGE(B2:Z2)

Arvi Laanemets

dividing a row

LostNFound

Gary Brown

Arvi Laanemets