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

  • 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

  • Hello,


    Without your file ...

    if you need to work out the Average of Column J as a function of Column E ..


    may be :

    Code
    =IFERROR(AVERAGEIF(E3:E18,">0",J3:J18),0)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!