dividing a row

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

=Average(B2:Z2)
HTH,
Gary Brown


"LostNFound" wrote:

> 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

Hi

=AVERAGE(B2:Z2)


Arvi Laanemets


"LostNFound" <GottaGo2@Hotmail.com> wrote in message
news:D3EE75C6-2936-47D8-BDB5-B2ED3E928564@microsoft.com...
> 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