答案1
当高级功能失败时..构建一个。[我的手动 sumifs]:
=SUMIF(B2:B5,"a",C2:C5)+SUMIF(B2:B5,"c",C2:C5)+SUMIF(B2:B5,"a",D2:D5)+SUMIF(B2:B5,"c",D2:D5)
希望能帮助到你..
当高级功能失败时..构建一个。[我的手动 sumifs]:
=SUMIF(B2:B5,"a",C2:C5)+SUMIF(B2:B5,"c",C2:C5)+SUMIF(B2:B5,"a",D2:D5)+SUMIF(B2:B5,"c",D2:D5)
希望能帮助到你..