How to get ride of when using a nested AVERAGEIF formula

[TMCINNIS]

I need some help.

I have a formula below that is giving the average of all page view values on monthly tables on another worksheet. Where there is data, this formula works fine. However, where there is no data for that month, I am getting the #DIV/0! error

=AVERAGEIFS('REPORT-PAGE CATs AE PSP GB'!CN$3:CN$1048576,'REPORT-PAGE CATs AE PSP GB'!$E$3:$E$1048576,"*http://smith.jones.com/abc/portal/efg/residential*")

I tried using IFERROR to correct this, but I am getting a formula error message.

=IFERROR(AVERAGEIF('REPORT-PAGE CATs AE PSP GB'!CN$3:CN$1048576,'REPORT-PAGE CATs AE PSP GB'!$E$3:$E$1048576,"*http://smith.jones.com/abc/portal/efg/residential*")

Any help is greatly appreciated.

 

[Jonmo1]

You have to specify what should happen when it's an error..
I assume you want it to return blank ""

Try
=IFERROR(AVERAGEIF('REPORT-PAGE CATs AE PSP GB'!CN$3:CN$1048576,'REPORT-PAGE CATs AE PSP GB'!$E$3:$E$1048576,"*http://smith.jones.com/abc/portal/efg/residential*"),"")

 

[TMCINNIS]

You have to specify what should happen when it's an error..
I assume you want it to return blank ""

Try
=IFERROR(AVERAGEIF('REPORT-PAGE CATs AE PSP GB'!CN$3:CN$1048576,'REPORT-PAGE CATs AE PSP GB'!$E$3:$E$1048576,"*http://smith.jones.com/abc/portal/efg/residential*"),"")

Thank you very much. I was certain I had included that in all my attempts, but sure enough, I missed it. Your correction worked.

Thank you again.

 

[Jonmo1]

You're welcome.