• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Nested IF functions in combo with SUMPRODUCT

P

phillygirl777

Member
Hello,


I am getting an error message when trying to use nested IF functions. There are only 3 possibilities, and I am getting an error message "Too Many Arguments." Is there a character limit in Excel 2007? When I omit one of the "IF"s, the function works properly.
 
Hi Phillygirl777,


Firstly, Welcome to Chandoo.org!!


To easily address your issue, you need to be more detailed and provide your current formula. The bug may be related to usage of open or close braces "()".


Regards,

Prasad
 
The too many arguements is saying that you probably have the commas/parenthesis in wrong place. Check your comma placement, or post a copy of the formula here?
 
Thank you! Here is the formula that is working:


=IF($E$3="IP",SUMPRODUCT((Accts=$C14)*('Sheet 1'!V$6:AG$6="Actual")*('Sheet 1'!$V$16:$AG$91)),IF($E$3="LS",SUMPRODUCT((Accts=$C14)*('Sheet 1'!AJ$6:AU$6="Actual")*('Sheet 1'!$AJ$16:$AU$91))))


And when I add another IF statement to account for the third, and final, possibility, I get an error message:


=IF($E$3="IP",SUMPRODUCT((Accts=$C14)*('Sheet 1'!V$6:AG$6="Actual")*('Sheet 1'!$V$16:$AG$91)),IF($E$3="LS",SUMPRODUCT((Accts=$C14)*('Sheet 1'!AJ$6:AU$6="Actual")*('Sheet 1'!$AJ$16:$AU$91))),IF($E$3="SSR",SUMPRODUCT((Accts=$C14)*('Sheet 1'!AX$6:BI$6="Actual")*('Sheet 1'!$AX$16:$BI$91))))


Your help is greatly appreciated
 
Not sure what you're wanting if E3 doesn't match any criteria, so came up with this:

=IF($E$3="IP",SUMPRODUCT((Accts=$C14)*('Sheet 1'!V$6:AG$6="Actual")*('Sheet 1'!$V$16:$AG$91)),IF($E$3="LS",SUMPRODUCT((Accts=$C14)*('Sheet 1'!AJ$6:AU$6="Actual")*('Sheet 1'!$AJ$16:$AU$91)),IF($E$3="SSR",SUMPRODUCT((Accts=$C14)*('Sheet 1'!AX$6:BI$6="Actual")*('Sheet 1'!$AX$16:$BI$91)),"E3 is not IP, LS, or SSR")))


You had an extra parenthesis after the 2nd SUMPRODUCT. Alternatively, if there truly are only 3 choices for E3, your formula can be reduced further to:

=IF($E$3="IP",SUMPRODUCT((Accts=$C14)*('Sheet 1'!V$6:AG$6="Actual")*('Sheet 1'!$V$16:$AG$91)),IF($E$3="LS",SUMPRODUCT((Accts=$C14)*('Sheet 1'!AJ$6:AU$6="Actual")*('Sheet 1'!$AJ$16:$AU$91)),SUMPRODUCT((Accts=$C14)*('Sheet 1'!AX$6:BI$6="Actual")*('Sheet 1'!$AX$16:$BI$91))))
 
You don’t tiffany and co have to give up a thing on quality just because you are getting NHL jerseys cheap. They are attractively and authentically designed to look like the tiffany jewelry real thing. The fabrics used are selected to be very durable and long lasting. The stitching is secure and sturdy. There’s no special cleaning procedure required, either, so you can wear yours everywhere without worry.


You will find you’re all tiffany necklace of your favorite NHL teams and players, including All-Star jerseys. All of the most popular tiffany rings vintage and third jersey designs can be found, too. Of course you can get home game and away game designs. You will probably want one of tiffany bracelet each.
 
You must log in or register to reply here.
Back
Top