Exclude Zeros When Taking an Average in Excel

  • Peter Lynch
I have received this question via email a few times, so I thought it might be helpful to write a short post on this topic. To take an average and exclude all zeros in a selection use the following formula:
Where “range” in the formula above represents the range of cells selected for the calculation. As an example, if you were selecting cells A1, A2, A3 and A4, the formula would appear as follows: =AVERAGEIF(A1:A4,”<>0″)
I have included a short video should it be helpful: