How to make an avergae of a SUM IF formula

**pansovic** · 12-30-2011, 03:56 PM

I know how to use the SUMIF formula though I want to get the average of the result. Is that possible?

**zbor** · 12-30-2011, 04:03 PM

With Excel 2007 you can use AVERAGEIF formula same way

**pansovic** · 12-30-2011, 05:22 PM

Originally Posted by zbor

With Excel 2007 you can use AVERAGEIF formula same way

I tried but get a DIV/O error. In the whole column I do have empty cells but that is just the reason that I want to use AVERAGEIF so that I can choose those that have no 0

**zbor** · 12-30-2011, 05:29 PM

You get DIV error if there is no data.
You can use IFERROR function to avoid it: =IFERROR(formula, result)

**pansovic** · 12-30-2011, 06:10 PM

Originally Posted by zbor

You get DIV error if there is no data.
You can use IFERROR function to avoid it: =IFERROR(formula, result)

Doesn't solve because when I replace the error for example for a "0" than I will get the 0 but I need to get the average.
It is my understanding that in the Rank I can have empty cells but with the Criteria I choose the ones which are not empty. Is this correct or simply in the whole column I cannot have a 0 neither empty cell?