|
发表于 2014-7-24 09:22
|
显示全部楼层
本楼为最佳答案
B3- =SUM(SUMIFS(INDIRECT("'"&ROW($$4:$$8)&"月'!s:s"),INDIRECT("'"&ROW($$4:$$8)&"月'!b:b"),$$A3,INDIRECT("'"&ROW($$4:$$8)&"月'!o:o"),">="&DATE(2014,B$$2,1),INDIRECT("'"&ROW($$4:$$8)&"月'!o:o"),"<"&DATE(2014,B$$2+1,1)))
复制代码 三键横拉下拉
=SUM(SUMIFS(INDIRECT("'"&ROW($4:$8)&"月'!s:s"),INDIRECT("'"&ROW($4:$8)&"月'!b:b"),$A3,INDIRECT("'"&ROW($4:$8)&"月'!o:o"),">="&DATE(2014,B$2,1),INDIRECT("'"&ROW($4:$8)&"月'!o:o"),"<"&DATE(2014,B$2+1,1))) |
|