=IFERROR(SUMIF(入库!$D$6:$D$8168,$B5,入库!$F$6:$F$8164),"")
=IFERROR(IF(I5/G5=0,"",I5/G5),"")
=SUMIF(入库!$D$6:$D$8168,$B5,入库!$H$6:$H$8164)
=SUMIF(出库!$D$6:$D$8232,$B5,出库!$F$6:$F$8228)
=SUBTOTAL(9,F5:F1043)
=SUMIF($C5:$C1043,"kg",D5:D1043)
=SUMIF($C5:$C1043,"米",D5:D1043)
=SUM(SUMIF($C5:$C1043,{"卷","套","片","桶","支"},D5:D1043))
=SUMIF($V5:$V1043,"其他布",D5:D1043)
=SUMIF(报表!$B$5:$B$8357,$B4,报表!$M$5:$M$8353)
=IFERROR(L4/K4,"")
=IFERROR(VLOOKUP($D313,材料变单位,2,FALSE),"")
=IFERROR(VLOOKUP($D313,单价,2,FALSE),"")
=IFERROR(1/ROUND(G313*F313,)^-1,"")
=IFERROR(VLOOKUP($D313,材料变名,2,FALSE),"")
=TEXT(COUNTIF(D$6:D316,D316),"第0次;;")
=IFERROR(SUMIF(入库!$I$6:$I$1232,$P86,入库!$H$6:$H$1232),"")
=IF(G646="","",VLOOKUP(D646,报表!B:O,12,)*VLOOKUP(D646,客户名字!I:J,2,)-VLOOKUP(D646,报表!B:O,14,))
=IFERROR(H646-P646,"")
我这些公式有没有问题 |