ExcelBanter - dividing a row

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - dividing a row (https://www.excelbanter.com/excel-worksheet-functions/16493-dividing-row.html)

LostNFound

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

Gary Brown

=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

Arvi Laanemets

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

All times are GMT +1. The time now is 07:22 AM.