#DIV/0! Error

Is there a common way to allow add/average/sum functions to ignore this error & still complete the formula? For example... I have two tabs.. Tab A has my results, Tab B my data. In Tab A, I pull data from Tab B into cells A1 & A2.. in A3, I want to average the two. A1 is fine, but A2 has the #DIV/0! error as the data from Tab B is at times incomplete. When that happens, Cell A3 gives me the same DIV/0! error. I've tried using =IF(ISERROR(AVERAGE(A1:A2)),"-",AVERAGE(A1:A2)) which gets rid of the error, but it won't calculate the data.

I thought for a second, I should use the same formula in cells A1 & 2, but some of the data from Tab B already has very long formulas.. one of which I previously received help from on an earlier thread.

Any thoughts?

So, in A1 and A2:

=IFERROR(your_formula,"")

In other words, deal with each possible error message individually, not within the summative formula.

Try =averageif(a1:a2,">=0") or =aggregate(1,6,a1:a2)

Once again, yooos guys come to the rescue. The Dude abides..

The Dude abides where?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.