Calculate average excluding 0 and negative numbers

[owais0937]

Hi ,

I have a column of data that includes positive numbers, negative numbers and zeroes. different formulas,
like =SUMIF(G5:G9,">=0")/COUNTIF(G5:G9,">=0")
=AVERAGEIF(G5:G16,"<>0")
but I cant seem to get an average excluding both the zeroes and negative numbers. Does anyone have an idea how to make this work in Excel ? Thanks!

[canapone]

Hi

an attempt: to exclude zeros you don't need "="

=SUMIF(G5:G9,">0")/COUNTIF(G5:G9,">0")

To esclude negative numbers

=AVERAGEIF(G5:G16,">0")

Regards

[owais0937]

Hi

an attempt: to exclude zeros you don't need "="

=SUMIF(G5:G9,">0")/COUNTIF(G5:G9,">0")

To esclude negative numbers

=AVERAGEIF(G5:G16,">0")

Regards

Thank you !!
But i want single formula to calculate average for a range excluding negative and 0 values cells

[canapone]

Hi,

thanks for your kind feedback


=AVERAGEIF(G5:G16,">0")

should do the trick!

[owais0937]

Thank You ...