Ignoring empty cells
 

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

beeo Wrote:
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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=465833

Hi Beeo,

Use the AVERAGE function which ignores empty cells.


---
Regards,
Norman



"beeo" wrote in message
ups.com...
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

Yes of course - Thanks a lot