第1个回答 2012-11-04
SHEET2表中A列为月份,B列为日期的,A1&B1某月某日到A2&B2某月某日,
SHEET2表C列C2单元格输入公式
=SUM(INDIRECT("sheet1!c"&MATCH(A1&B1,Sheet1!A1:A100&Sheet1!B1:B99,)):INDIRECT("sheet1!c"&MATCH(A2&B2,Sheet1!A1:A100&Sheet1!B1:B99,)))
数组公式,按下SHIFT+CTRL+ENTER三键结束输入
或
=SUM(INDIRECT("sheet1!c"&MATCH(DATE(2012,A1,B1),DATE(2012,Sheet1!A1:A50,Sheet1!B1:B50),)):INDIRECT("sheet1!c"&MATCH(DATE(2012,A2,B2),DATE(2012,Sheet1!A1:A50,Sheet1!B1:B50),)))
数组公式,按下SHIFT+CTRL+ENTER三键结束输入本回答被提问者和网友采纳