2023-07-26 14:37发布
=SUMPRODUCT(SUMIF(A:A,C30,INDIRECT({C:C,D:D,E:E,F:F,G:G})))追问您好!这个是日
=SUMPRODUCT(SUMIF(A:A,"C30",INDIRECT({"C:C","D:D","E:E","F:F","G:G"})))追问
您好!这个是日期只有5天,如果是一个月呢?还是后面这个一直累加吗?
A列是名称从列到AG列是日期1-31号公式如下=SUM(MMULT((A$1:A$1000="C30")*(C$1:AG$1000),ROW($1:$31)^0))测试通过
最多设置5个标签!
=SUMPRODUCT(SUMIF(A:A,"C30",INDIRECT({"C:C","D:D","E:E","F:F","G:G"})))追问
追答 本回答被提问者采纳一周热门 更多>