0

How to calculate average of column without calculating empty cells

Tufan Oney

June 13, 2019 16:21

None

Follow

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

thanks...

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Janice Janczyn June 19, 2019 20:50

  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!

  Janice