Hi!

I have:

A B
1 x 100
2 y 0
3 z 200
4
5

I would like average B1:B5 if A1:A5 < ""
In this case: AVG=150

Thanks in advance.
an