Ignoring blank cells from and average and blank cell when #DIV/0

[Farruko]

Hi guys, I need help finding the best way to do this.
On column Weight (Kg) I add the number, on column weigh in (Pounds) I'v added in every cell: =F27*2.2 to get the number in pounds.
On average (lbs) I'm using the formula =AVERAGEIF(H27:H33,"<>0") to get the average and ignore the blank cells or zeros but I'm getting #DIV/0
To get rid of the #DIV/0 I've used before =IFERROR(AVERAGE(H27:H33),0)
How can I do both things, get the average ignoring blank cells and if #DIV/0 get a blank cell? to do that in the same cell is it possible?

Many thanks in advance, hope is not too confusing.

 

[RoryA]

Welcome to the forum.

Just wrap the AVERAGEIF in the IFERROR:

=IFERROR(AVERAGEIF(H27:H33,"<>0") ,0)

 

[Farruko]

Thank you very much!