How to calculate average of column without calculating empty cells

I need an average of specific column in excel without calculating zero values and empty cells. 


1 comment

  • 0
    Janice Janczyn

    Hi Tufan, thank you for posting in our community.

    The AVERAGE function will ignore blanks and non-numeric data. Or you can use the AVERAGEIF function to calculate the average of a list of values based on a specific criteria, for example in your case, to average only values not equal to 0, null or blank:

          AVERAGEIF( NOT( IN( @A:A, ARRAY(0, "", BLANK()))), @A:A )


    I hope this helps!


Please sign in to leave a comment.