Average

[an]

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]

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]

Ok, RG.

Perfect.
Many thanks.
an

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")