sumproduct多條件求和:sumproduct跨表多條件求和[朗讀]

試試=sumproduct((總清單!$m$2:$m$2100=」是「)*(總清單!$a$2:$a$2100=if($b$2=＂全部＂,總清單!$a$2:$a$2100,$b$2))*(總清單!$c$2:$c$2100=if($b$3=＂全部＂,總清單!$c$2:$c$2100,$b$3))*(總清單!$d$2:$d$2100=if($b$4=＂全部＂,總清單!$d$2:$d$2100,$b$4))*(總清單!$k$2:$k$2100=1),總清單!$q$2:$q$2100)。