IFERROR You have entered too many arguments for this function.

[tandkb]

Hi,

I am using the following formula.

=IF($A5=D$4,1,(SUMPRODUCT(($A5&$B5=Transfers!$H$5:$H$5000&Transfers!$C$5:$C$5000)*(D$4=Transfers!$G$5:$G$5000)*(Transfers!$K$5:$K$5000)))/SUMPRODUCT(($A5=Transfers!$H$5:$H$5000)*(Transfers!$K$5:$K$5000)))

It is working great in some cells but I am getting a#DIV/0! error in others. I realize I have a division by 0 error but can't really help that. When I try to do the IFERROR function it wont let me and give me an error that says you have entered too many arguments for this function. Is there something I can do here?

Thanks so much for your help!

 

[RoryA]

What do you want to return instead of the error? Basically it's:

=IF($A5=D$4,1,IFERROR((SUMPRODUCT(($A5&$B5=Transfers!$H$5:$H$5000&Transfers!$C$5:$C$5000)*(D$4=Transfers!$G$5:$G$5000)*(Transfers!$K$5:$K$5000)))/SUMPRODUCT(($A5=Transfers!$H$5:$H$5000)*(Transfers!$K$5:$K$5000)),""))

and you can change the red part to whatever you like.

 

[tandkb]

That worked perfect! Thanks so much for your help!!

 

[RoryA]

Glad to help.