"You've entered too many arguments for this function." Nesting IF statements

[IZABELLABEAN]

I am BRAND NEW to the forum so any help is very much desired. I am trying to figure out what I did wrong on the following equation:

=IF(Refi!$C$2>Proforma!L3, SUMIF('1st Mort'!$B$17:$B$256,Proforma!L3,'1st Mort'!$E$17:$E$256)+SUMIF('1st Mort'!$B$17:$B$256,Proforma!L3,'1st Mort'!$F$17:$F$256),+SUMIF('2nd Mort'!$B$18:$B$257,Proforma!L3,'2nd Mort'!$E$18:$E$257),+
SUMIF('2nd Mort'!$B$18:$B$257,Proforma!L3,'2nd Mort'!$F$18:$F$258),+SUMIF(Refi!$B$19:$B$174,Proforma!L3,Refi!$D$19:$D$174),+
SUMIF(Refi!$B$19:$B$174,Proforma!L3,Refi!$E$19:$E$174))

I have three amortization tables I'm trying to pull from on three separate worksheets.

Thank you!

 

[par60056]

welcome to the forum.

It looks like you were doing some copy/paste in your formulas. There are a lot of places where there is a comma before a Plus. ,+ Take a look at those and see which things should be added together and where the false condition starts.