Getting Rid of an #DIV/0! Error

[Candis_k]

I am calculating an average from another workbook and am trying to get rid of this error without having to insert a 0. I have tried an IFError but cannot figure it out. This is my formula:

=AVERAGE('\\netapp5\group\CommunityServices\^Department\Aquatics Files\Batherloads\Monthly Batherload 2019\[DHRC Monthly Batherload 2019.xlsm]January 2019'!$B$9:$AK$9)

Thanks!

 

[dafly]

=iserror(AVERAGE('\\netapp5\group\CommunityServices\^Department\Aquatics Files\Batherloads\Monthly Batherload 2019\[DHRC Monthly Batherload 2019.xlsm]January 2019'!$B$9:$AK$9),””)

Try that.

 

[sandy666]

maybe:

=IFERROR(AVERAGE('\\netapp5\group\CommunityServices\^Department\Aquatics Files\Batherloads\Monthly Batherload 2019\[DHRC Monthly Batherload 2019.xlsm]January 2019'!$B$9:$AK$9),"")

 

[dafly]

Oops, yea, what sandy said.