第1个回答 2009-05-12
定义名称
shname
=REPLACE(GET.DOCUMENT(76),1,FIND("]",GET.DOCUMENT(76)),)&T(NOW())
shnames
=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),)&T(NOW())
sh
=LOOKUP(SMALL(IF(shname<>shnames,COLUMN(INDIRECT("c1:c"&COUNTA(shnames),0))),ROW(INDIRECT("1:"&COUNTA(shnames)-1))),MATCH(shnames,shnames,),shnames)
最后你的公式改为
=ROUND(SUM(SUMIF(indirect("'"&sh&"'!A:A"),CONCATENATE($L$3,L$5,"加工"),合计!$P:$P))/1000,)
数组公式,按CTRL+SHIFT+回车三键确定,无论你增加多少表格,公式中都会自动增加,不用手动一个个加本回答被提问者和网友采纳
第5个回答 2009-05-12
=ROUND(SUM(SUMIF(INDIRECT({"小记","结算"}&"!$A:$A"),CONCATENATE($L$3,L$5,"加工"),合计!$P:$P))/1000,0)