Avg() function only using populated cells

[masterdineen]

Hello there

I want to get an avg of column, But instead of including all cells for future eg avg(A1:A999999)


is there a way i could just include cell that are populated.?

Regards

Rob

[Pepe Le Mokko]

Perhaps the AVERAGEIF function?

[masterdineen]

could you give an example please

[Ace_XL]

But instead of including all cells for future eg avg(A1:A999999)
is there a way i could just include cell that are populated.?

Excel will still ignore blank and non-numeric cells while calculating the Average function

[kvsrinivasamurthy]

Pl Try

=AVERAGEIF(A1:A999999,">0")

[masterdineen]

thank you once again.

Top bannana

[Ace_XL]

=AVERAGEIF(A1:A999999,">0")

What about negative values (if any) and legitimate zero values, should these be excluded from the calculation?

[Fotis1991]

As Ace_XL said..

=AVERAGE(A:A) and =AVERAGEIF(A1:A999999,">0"), gives same results.



Edit. For positive numbers