計算三維 提货次数與总额 (9412)

L3:M5 {=SUM(IFERROR(C$3:G$7^(A$1=$B$1),)*(C$2:G$2=C$2)*($A$3:$A$7=$J3))

格式化 B3:B7=$D3+$F3+$H3<>$B3