Ignoring empty cells

beeo · 09-08-2005, 04:05 AM

Hi all

let say I have the following row of information

112
98
empty
123
99
empty
empty
99
100
120

Now I want to add the row and divide it by the full cells (no empty)
the result beeing an average (751 / 7 = 107,29) How can I
do this?

Tia

**Paul Sheppard** · 09-08-2005, 04:17 AM

Originally Posted by beeo

Hi all

let say I have the following row of information

112
98
empty
123
99
empty
empty
99
100
120

Now I want to add the row and divide it by the full cells (no empty)
the result beeing an average (751 / 7 = 107,29) How can I
do this?

Tia

Hi beeo

Use the AVERAGE function > =AVERAGE(A1:A10), it ignores the empty cells

Norman Jones · 09-08-2005, 05:05 AM

Hi Beeo,

Use the AVERAGE function which ignores empty cells.

---
Regards,
Norman

"beeo" <[email protected]> wrote in message
news:[email protected]...
> Hi all
>
> let say I have the following row of information
>
> 112
> 98
> empty
> 123
> 99
> empty
> empty
> 99
> 100
> 120
>
> Now I want to add the row and divide it by the full cells (no empty)
> the result beeing an average (751 / 7 = 107,29) How can I
> do this?
>
> Tia
>