excel关于sumif和sumifs函数对多行多列区域求和问题,求解。

发布网友 发布时间：2022-04-25 07:03

我来回答

共1个回答

热心网友 时间：2023-11-05 14:53

分别求和再相加：
=SUMIF(A2:A1000,"张三",B2:B1000)+=SUMIF(A2:A1000,"张三",C2:C1000)+=SUMIF(A2:A1000,"张三",D2:D1000)+=SUMIF(A2:A1000,"张三",E2:E1000)

热心网友 时间：2023-11-05 14:53

分别求和再相加：
=SUMIF(A2:A1000,"张三",B2:B1000)+=SUMIF(A2:A1000,"张三",C2:C1000)+=SUMIF(A2:A1000,"张三",D2:D1000)+=SUMIF(A2:A1000,"张三",E2:E1000)

热心网友 时间：2023-11-05 14:53

分别求和再相加：
=SUMIF(A2:A1000,"张三",B2:B1000)+=SUMIF(A2:A1000,"张三",C2:C1000)+=SUMIF(A2:A1000,"张三",D2:D1000)+=SUMIF(A2:A1000,"张三",E2:E1000)

热心网友 时间：2023-11-05 14:53

分别求和再相加：
=SUMIF(A2:A1000,"张三",B2:B1000)+=SUMIF(A2:A1000,"张三",C2:C1000)+=SUMIF(A2:A1000,"张三",D2:D1000)+=SUMIF(A2:A1000,"张三",E2:E1000)

热心网友 时间：2023-11-05 14:53

分别求和再相加：
=SUMIF(A2:A1000,"张三",B2:B1000)+=SUMIF(A2:A1000,"张三",C2:C1000)+=SUMIF(A2:A1000,"张三",D2:D1000)+=SUMIF(A2:A1000,"张三",E2:E1000)

热心网友 时间：2023-11-05 14:53

分别求和再相加：
=SUMIF(A2:A1000,"张三",B2:B1000)+=SUMIF(A2:A1000,"张三",C2:C1000)+=SUMIF(A2:A1000,"张三",D2:D1000)+=SUMIF(A2:A1000,"张三",E2:E1000)