IF with #DIV/0!

[DKY]

I have a function that gives an average of a certain cell on each sheet
on the same cell in the current sheet that looks like so.
=AVERAGE(sheet1:sheet2!H53)

Problem is that when there's nothing in these cells on the other sheets
this formula gives me the #DIV/0!. I would like to know how to use IF
so that IF the outcome is #DIV/0! it puts nothing in the cell, so that
I don't have a sheet full of #DIV/0!. I'm having a problem trying to
figure this out though. I have it backwards or something, and I don't
know how to put, or if I even can put #DIV/0! in a function. Any
suggestions?

 

[Frank Kabel]

Hi
try:
=IF(COUNT(sheet1!H53,sheet2!H53),AVERAGE(sheet1:sheet2!
H53),"")

 

[papou]

Hello
=IF(ISERROR(AVERAGE(sheet1:sheet2!H53));"";AVERAGE(sheet1:sheet2!H53))
HTH
Cordially
Pascal