Average

an · Jan 28, 2008

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

Roger Govier · Jan 28, 2008

Hi

From the result you are showing, you want to exclude 0 values, not nulls.
The average function automatically excludes nulls.
Try
=AVERAGEIF(B1:B3,"<>0")

an · Jan 28, 2008

Ok, RG.

Perfect.
Many thanks.
an

Roger Govier said:
Hi

From the result you are showing, you want to exclude 0 values, not nulls.
The average function automatically excludes nulls.
Try
=AVERAGEIF(B1:B3,"<>0")