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
|