Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=AVERAGE(IF(A1:A100<0,A1:A100))
--
Regards
Frank Kabel
Frankfurt, Germany
"Alex" schrieb im Newsbeitrag
...
Hi everybody,
I have a column as follows:
12%
0
10%
0
0
5%
The aver. % will be 9%. But, if we take 0 into consideration it will
be 4.5%.
How could I the Average formula without taking this 0 into
consideration?
Thanks
|