Remove #Div/0! Error from a Complicated Formula

[Jtucker10278]

The formula I'm Working with is an Average of values in intersecting ranges found using the indirect function.

=AVERAGE(INDIRECT(B$9) INDIRECT($A15))

Really the formula is

=Average(Range Range)

The problem is that sometimes all the values will be 0. (or more accurately there are no values entered into the cells

I understand the #Div/0! Error and why I am getting it I'm just not sure how to remove the error from this formula

I have been trying =IFerror but I am not understanding how to incorporate it properly to make it work.

Thanks for the help

 

[Aladin Akyurek]

Like this...

=IFERROR(AVERAGE(INDIRECT(B$9) INDIRECT($A15)),””)

 

[Jtucker10278]

Yup, it was that part on the end I was forgetting about.

I even looked up IFERROR I just didnt bother to read it all the way to the end of the formula.

Thanks

 

[Aladin Akyurek]

You are welcome.