Ignoring empty cells

B

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
 
P

Paul Sheppard

beeo said:
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
Click to expand...

Hi beeo

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