IF with #DIV/0!


D

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?
 
Ad

Advertisements

F

Frank Kabel

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

Advertisements

P

papou

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#DIV/0! 2
#DIV/0! 3
#DIV/0! 1
#DIV/0 3
IF with #DIV/0! 1
DIV/0! 2
#DIV/0 2
#div/0 1

Top