#Div/0 won't dissapear

[VFrank]

Hey guys and/or girls!

So I started making some more complex use of excel and I have come to an little problem.
If I do:

=AVERAGEIF(E26:J26, "<>0")+K26

Info:
- E26:J26 can be a number but also N/A atm
- K26, same as above

but I keep getting those #Div/0 warnings, is there anyway to get rid of those?

Thanks in advance!

 

[MR_J3NKO]

You can use IFERROR to be rid of those

Try this:

=IFERROR(AVERAGEIF(E26:J26, "<>0")+K26,0)

Hope that helps

 

[VFrank]

That worked, thanks!