averaging formula help

[andrewb90]

I have to average K10:K15 but sometimes K15 will not have any data totaled to it and therefore will result in zero, how do I average all the other numbers except for the zeros?

Thanks,

Andrew

 

[kpark91]

=averageif(k10:k15,"<>""""")

 

[andrewb90]

I seem to be getting a #DIV/0 when I enter that even with all fields full of numbers.

 

[kpark91]

=averageif(k10:k15,"<>0")

 

[Aladin Akyurek]

I have to average K10:K15 but sometimes K15 will not have any data totaled to it and therefore will result in zero, how do I average all the other numbers except for the zeros?

Thanks,

Andrew

Try something like...

=AVERAGEIF(K10:K15,">0")

With some control:

=IFERROR(AVERAGEIF(K10:K15,">0"),"")

Generic for all Excel versions...

=SUMIF(K10:K15,">0")/COUNTIF(K10:K15,">0")

With some control:

=SUMIF(K10:K15,">0")/MAX(1,COUNTIF(K10:K15,">0"))

 

[andrewb90]

Awesome, Thanks guys

 

[Aladin Akyurek]

Awesome, Thanks guys

You are welcome. Thanks for providing us feedback.