average function includes blank or #N/A

[dgavilanes]

Quick Q?


when I do the average on this column, I get the #N/A in the result, how do I adusted so it output is correct


51.8%

#N/A

37.0%

51.2%

53.5%

34.4%

-------

#N/A


Thanks Dennis

 

[SirJB7]

Hi, dgavilanes!


Tried this?

=PROMEDIO.SI(A1:A6;">=0";A1:A6) -----> in english: =AVERAGEIF(A1:A6,">=0",A1:A6)


Regards!

 

[dgavilanes]

Thank you !!! you are a "genius"

 

[Trader273]

If you are using excel 2010, you can always use the new "Aggregate" feature. Though since it's a new function it's not backwards compatible.

 

[SirJB7]

Hi, dgavilanes!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!