一、=SUM(DSUM(INDIRECT({"一","二","三","四","五","六"}&"年级汇总"&"!a1:e500"),5,$A$1:$A2))
二、=SUM(SUMIF(INDIRECT({"一";"二";"三";"四";"五";"六"}&"年级汇总"&"!a:a"),"黄小",INDIRECT({"一";"二";"三";"四";"五";"六"}&"年级汇总"&"!e:e")))
三、=SUMPRODUCT(SUMIF(INDIRECT({"一","二","三","四","五","六"}&"年级汇总"&"!a:a"),A2,INDIRECT({"一","二","三","四","五","六"}&"年级汇总"&"!e:e")))
给个图，帮你看看
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024