求大神帮忙，表格汇总

zhujinglai

本人初学者，请大神帮忙设计下汇总公式，谢谢!

hugeinfo

f3=SUMPRODUCT((--(INDIRECT(SUBSTITUTE(LOOKUP("座",$F$1:F$1,$F$1:F$1),CHAR(10),"")&"!A2:A500")=汇总!$A3))*INDIRECT(SUBSTITUTE(LOOKUP("座",$F$1:F$1,$F$1:F$1),CHAR(10),"")&"!b2:b500"))  
g3=SUMPRODUCT((--(INDIRECT(SUBSTITUTE(LOOKUP("座",$F$1:F$1,$F$1:F$1),CHAR(10),"")&"!A2:A500")=汇总!$A3))*INDIRECT(SUBSTITUTE(LOOKUP("座",$F$1:F$1,$F$1:F$1),CHAR(10),"")&"!c2:c500"))
h3=SUMPRODUCT((--(INDIRECT(SUBSTITUTE(LOOKUP("座",$F$1:F$1,$F$1:F$1),CHAR(10),"")&"!A2:A500")=汇总!$A3))*INDIRECT(SUBSTITUTE(LOOKUP("座",$F$1:F$1,$F$1:F$1),CHAR(10),"")&"!d2:d500"))
i3=SUMPRODUCT((--(INDIRECT(SUBSTITUTE(LOOKUP("座",$F$1:F$1,$F$1:F$1),CHAR(10),"")&"!A2:A500")=汇总!$A3))*INDIRECT(SUBSTITUTE(LOOKUP("座",$F$1:F$1,$F$1:F$1),CHAR(10),"")&"!e2:e500"))

选中三列向右向下拉

chen301222

试试vba代码