看看我的公式能不能做个简化，实在是太长了

墨西哥の早晨

这个公式的意思是在表格week28到表格week33中，B列的等于查询表B3，K列的等于查询表的D3,F列数单位PCS，L列文字是报废，就求和表格week28到表格week33中
E列。E列式数字。表格week28到表格week33的格式是一样的。
查询表=SUMPRODUCT((week28!$B$8:$B$999=B3)*(week28!$K$8:$K$999=D3)*(week28!$F$8:$F$999="PCS")*(week28!$L$8:$L$999="报废"),week28!$E$8:$E$999)+SUMPRODUCT((week29!$B$8:$B$999=B3)*(week29!$K$8:$K$999=D3)*(week29!$F$8:$F$999="PCS")*(week29!$L$8:$L$999="报废"),week29!$E$8:$E$999)+SUMPRODUCT((week30!$B$8:$B$999=B3)*(week30!$K$8:$K$999=D3)*(week30!$F$8:$F$999="PCS")*(week30!$L$8:$L$999="报废"),week30!$E$8:$E$999)+SUMPRODUCT((week31!$B$8:$B$999=B3)*(week31!$K$8:$K$999=D3)*(week31!$F$8:$F$999="PCS")*(week31!$L$8:$L$999="报废"),week31!$E$8:$E$999)+SUMPRODUCT((week32!$B$8:$B$999=B3)*(week32!$K$8:$K$999=D3)*(week32!$F$8:$F$999="PCS")*(week32!$L$8:$L$999="报废"),week32!$E$8:$E$999)+SUMPRODUCT((week32!$B$8:$B$999=B3)*(week32!$K$8:$K$999=D3)*(week32!$F$8:$F$999="PCS")*(week32!$L$8:$L$999="报废"),week32!$E$8:$E$999)+SUMPRODUCT((week33!$B$8:$B$999=B3)*(week33!$K$8:$K$999=D3)*(week33!$F$8:$F$999="PCS")*(week33!$L$8:$L$999="报废"),week33!$E$8:$E$999)

wshcw

多表,多条件求和,不好实现.