=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 Answer
You're missing a close bracket in this part of your formula:
SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ap:$ap,
right here^
IF
statements (maybeSUMIFS
). Can you edit your question to describe what you're trying to accomplish. Some sample data and the expected outcome would also be useful