C1:E1单元格复制以下公式,下拉,
再复制 C4:E28 区域,粘贴到后面各个月份表格中;
C1
=TEXT(SUMIF(INDIRECT("'"&LOOKUP("坐",$A$2:E$2)&"'!$A:$A"),$A4,INDIRECT("'"&LOOKUP("坐",$A$2:E$2)&"'!$C:$C")),"0;;")
D1
=IF(C4="","",VLOOKUP($A4,INDIRECT("'"&LOOKUP("坐",$A$2:E$2)&"'!$A$3:$D$200"),4,))
E1
=IF(C4="","",C4*D4)