=IF($C$3=BuySellBillable!$W$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$w:$w),IF($C$3=BuySellBillable!$X$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!x:x),IF($C$3=BuySellBillable!$Y$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!y:y),IF($C$3=BuySellBillable!$Z$6,SUMIF(BuySellBillable!$A:$A,'DL分析'!$B7,BuySellBillable!z:z),如果($C$3=BuySellBillable!$AA$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!Aa:Aa),如果($C$3=BuySellBillable!$AB$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!ab:Ab),如果($C$3=BuySellBillable!$AC$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$ac:$ac),如果($C$3=BuySellBillable!$AD$6,SUMIF(BuySellBillable!$A:$A,'DL分析'!$B7,BuySellBillable!$ad:$ad),如果($C$3=BuySellBillable!$AE$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$ae:$ae),如果($C$3=BuySellBillable!$AF$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$af:$af),如果($C$3=BuySellBillable!$AG$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$ag:$ag),如果($C$3=BuySellBillable!$AH$6,SUMIF(BuySellBillable!$A:$A,'DL分析'!$B7,BuySellBillable!$ah:$ah),如果($C$3=BuySellBillable!$AI$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$ai:$ai),如果($C$3=BuySellBillable!$AJ$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$aj:$aj),如果($C$3=BuySellBillable!$AK$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$ak:$ak),如果($C$3=BuySellBillable!$AL$6,SUMIF(BuySellBillable!$A:$A,'DL分析'!$B7,BuySellBillable!$al:$al),IF($C$3=BuySellBillable!$AM$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$am:$am),IF($C$3=BuySellBillable!$AN$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$an:$an),IF($C$3=BuySellBillable!$AO$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$ao:$ao),IF($C$3=BuySellBillable!$AP$6,SUMIF(BuySellBillable!$A:$A,'DL分析'!$B7,BuySellBillable!$ap:$ap,如果($C$3=BuySellBillable!$AQ$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$aq:$aq),如果($C$3=BuySellBillable!$AR$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$ar:$ar),如果($C$3=BuySellBillable!$AS$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'!$B7,BuySellBillable!$as:$as),如果($C$3=BuySellBillable!$AT$6,SUMIF(BuySellBillable!$A:$A,'DL分析'！$B7,BuySellBillable!$at:$at),IF($C$3=BuySellBillable!$AU$6,SUMIF(BuySellBillable!$A:$A,'DL 分析'！$B7,BuySellBillable!$au:$au),0))))))))))))))))))))))))))))
答案1
公式的这一部分缺少右括号：
SUMIF(BuySellBillable!$A:$A,'DL Analysis'!$B7,BuySellBillable!$ap:$ap,
right here^