-4

=IF($C$3=BuySellBillable!$W$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$w:$w),IF($C$3=BuySellBillable!$X$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!x:x),IF($C$3=BuySellBillable!$Y$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!y:y),IF($C$3=BuySellBillable!$Z$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!z:z),IF($C$3=BuySellBillable!$AA$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!Aa:Aa),IF($C$3=BuySellBillable!$AB$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!ab:Ab),IF($C$3=BuySellBillable!$AC$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ac:$ac),IF($C$3=BuySellBillable!$AD$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ad:$ad),IF($C$3=BuySellBillable!$AE$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ae:$ae),IF($C$3=BuySellBillable!$AF$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$af:$af),IF($C$3=BuySellBillable!$AG$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ag:$ag),IF($C$3=BuySellBillable!$AH$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ah:$ah),IF($C$3=BuySellBillable!$AI$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ai:$ai),IF($C$3=BuySellBillable!$AJ$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$aj:$aj),IF($C$3=BuySellBillable!$AK$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ak:$ak),IF($C$3=BuySellBillable!$AL$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$al:$al),IF($C$3=BuySellBillable!$AM$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$am:$am),IF($C$3=BuySellBillable!$AN$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$an:$an),IF($C$3=BuySellBillable!$AO$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ao:$ao),IF($C$3=BuySellBillable!$AP$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ap:$ap,IF($C$3=BuySellBillable!$AQ$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$aq:$aq),IF($C$3=BuySellBillable!$AR$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ar:$ar),IF($C$3=BuySellBillable!$AS$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$as:$as),IF($C$3=BuySellBillable!$AT$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$at:$at),IF($C$3=BuySellBillable!$AU$6,SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$au:$au),0)))))))))))))))))))))))))

  • 1
    Well, there are too many arguments (see this for a list of Excel limits). That being said, there is surely a better way to go about it that tons of nested IF statements (maybe SUMIFS). Can you edit your question to describe what you're trying to accomplish. Some sample data and the expected outcome would also be useful – cybernetic.nomad Oct 5 '18 at 2:27
  • This looks like it could be speech-to-text output from a stock trading floor! – Michael Frank Oct 5 '18 at 2:59
  • I think unnecessarily you have use so many IFs , this can be testes in better way using other logical test options,, I would like to suggest you share some sample data with us or share the file on cloud, help us to fix it soon. !! ☺ – Rajesh S Oct 5 '18 at 3:20
  • I was trying to effectively amalgamate a H Look up and a V Look Up. I need to find precise figures in a unfortunately uneditable table with 23 columns and 300 rows where the data (The result also have to be fluid as the data in the tables is frequently sorted and filtered by different factors) – James Varricchio Oct 5 '18 at 3:44
-1

You're missing a close bracket in this part of your formula:

SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ap:$ap,
                                                           right here^

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.