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)。