IFERROR still returns #VALUE, Needs to be "" or 0

Happy Monday!

I have a formula that returns a #VALUE error when no data is available and I need it to either be nothing or 0. The error states that a value in the formula is of the wrong data type. I don't understand why the IFERROR doesn't work for this...

=IF(E34="","",IFERROR(INDEX(WPnStats!$E$1:$E$3458,MATCH($G$1&$E34,WPnStats!$B$1:$B$3458&WPnStats!$A$1:$A$3458,0)),0))+IFERROR(INDEX(WPnStats!$E$1:$E$3458,MATCH($G$1&$M34,WPnStats!$B$1:$B$3458&WPnStats!$A$1:$A$3458,0)),0)

The same formula for other cells works fine and return the correct values when their E cell has data in it.

Does anyone have an idea of how I can fix this?

Thanks very much for your help!

change with this one

=IFERROR(IF(E34="","",INDEX(WPnStats!$E$1:$E$3458,MATCH($G$1&$E34,WPnStats!$B$1:$B$3458&WPnStats!$A$1:$A$3458,0))+INDEX(WPnStats!$E$1:$E$3458,MATCH($G$1&$M34,WPnStats!$B$1:$B$3458&WPnStats!$A$1:$A$3458,0)),0)

You need to enclose the second part in brackets...

Formula:

=IF(E34="","",(IFERROR(INDEX(WPnStats!$E$1:$E$3458,MATCH($G$1&$E34,WPnStats!$B$1:$B$3458&WPnStats!$A$1:$A$3458,0)),0))+IFERROR(INDEX(WPnStats!$E$1:$E$3458,MATCH($G$1&$M34,WPnStats!$B$1:$B$3458&WPnStats!$A$1:$A$3458,0)),0))

It seems to be an array formula and requires Ctrl+Shift+Enter.

Hi everyone, thanks for all of the quick replies. Yes, I had used Ctrl+Shift+Enter. As it turns out, NBVC's formula in post #3 fixed it. Thanks, NBVC!