How do I average multiple columns (ignoring zeros and blank cells)?

[yeto]

I am trying to average multiple columns (ignoring zeros and blank cells). I have tried the following formulas. Neither is working. Could someone share as to what I may be dong incorrectly?

=iferrors(AVERAGEIF(E3:E18,J3:J18,">0"),0)
=iferrors(AVERAGEIFs(E3:E18,J3:J18,">0"),0)

Thank you in advance for any help,
yeto

[popipipo]

=AVERAGEIFS(E3:E18,J3:J18,">0")

Have you tried this formula?

[Pepe Le Mokko]

@yeto

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

[Pepe Le Mokko]

Which error do you get ? #DIV0! ?

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Please add links to ALL your cross posts ( at least three)

[yeto]

I am using Excel 2010.

Cross posts:
https://www.excelforum.com/excel-for...ml#post5270732

https://www.mrexcel.com/board/thread...cells.1122644/

https://www.excelguru.ca/forums/show...d-blank-cells)

https://www.ozgrid.com/forum/index.p...60#post1229460

https://chandoo.org/forum/threads/ho...k-cells.43532/

[yeto]

=AVERAGEIFS(E3:E18,J3:J18,">0")

Have you tried this formula?

That works but when all cells are blank the formula cell shows "#DIV/0!" without quotation marks which I am afraid might cause some confusion. Is it possible for the cell to show 0 when blank?

Thank you for taking time to answer,
yeto

[yeto]

Which error do you get ? #DIV0! ?

both formulas show: #NAME?

Thank you for taking time to help,
yeto

[JeteMc]

There is no "s" at the end of the IFERROR function.
Try: =IFERROR(AVERAGEIFS(E3:E18,J3:J18,">0"),0)
Let us know if you have any questions.