Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=AVERAGE(IF(A1:A100<0,B1:B100))

--
Regards
Frank Kabel
Frankfurt, Germany

"Vlookup help" schrieb im
Newsbeitrag ...
Hi,

Please let me know if there is a formula that allows me to do the
following:

A1 A2
AVG: 5
0 5
3
0 2
7
5
0 1

I just want the average to reflect the average of the numbers in
column A2
where column A1 does not have a zero.

Thanks