发布网友
共4个回答
热心网友
使用下列公式之一
=OFFSET(工时统计!E$16,(ROW(A1)-1)*16+1,)+OFFSET(工时统计!F$16,(ROW(A1)-1)*16+1,)-OFFSET(工时统计!H$17,(ROW(A1)-1)*16+1,)
=OFFSET(工时统计!E$1,ROW(A1)*16,)+OFFSET(工时统计!F$1,ROW(A1)*16,)-OFFSET(工时统计!H$1,ROW(A1)*16+1,)
=INDEX(工时统计!E:E,ROW(A1)*16+1)+INDEX(工时统计!F:F,ROW(A1)*16+1)-INDEX(工时统计!H:H,ROW(A1)*16+2)
=INDIRECT("工时统计!E"&ROW(A1)*16+1)+INDIRECT("工时统计!F"&ROW(A1)*16+1)-INDIRECT("工时统计!H"&ROW(A1)*16+2)
下拉填充
热心网友
=OFFEST(工时统计!$E$16,(ROW(A1)-1)*16+1)+OFFEST(工时统计!$F$16,(ROW(A1)-1)*16+1)-OFFEST(工时统计!$H$16,(ROW(A1)-1)*16+1)
或者:
=INDEX(工时统计!E:E,ROW(A1)+1)+INDEX(工时统计!F:F,ROW(A1)+1)-INDEX(工时统计!H:H,ROW(A1)+1)
热心网友
=SUM(OFFSET(工时统计!E17,16*(ROW(A1)-1), , ,2))+SUM(OFFSET(工时统计!H18,16*(ROW(A1)-1), ))追答=SUM(OFFSET(工时统计!E17,16*(ROW(A1)-1), , ,2))-SUM(OFFSET(工时统计!H18,16*(ROW(A1)-1), ))
后面只有一个单元格则可去掉sum
=SUM(OFFSET(工时统计!E17,16*(ROW(A1)-1), , ,2))-OFFSET(工时统计!H18,16*(ROW(A1)-1), )
热心网友
=INDIRECT("工时统计!E"&1+ROW(A1)*16)+INDIRECT("工时统计!F"&1+ROW(A1)*16)-INDIRECT("工时统计!H"&2+ROW(A1)*16)
公式下拉