=SUMIF(A:A,"华南区",B:B)
=SUMIFS(B:B,A:A,"华南区",C:C,"转账")
=COUNTIFS(A:A,"华南区",C:C,"转账")
=SUMPRODUCT((A2:A999="华南区")*(C2:C999="转账"),B2:B999)
=SUMPRODUCT((A2:A999="华南区")*(C2:C999="转账"))
微信扫一扫加关注,Office自学网官方微信公众号,
专注分享软件安装和视频教程,让你一号在手,办公无忧!
=SUMIF(A:A,"华南区",B:B)
=SUMIFS(B:B,A:A,"华南区",C:C,"转账")
=COUNTIFS(A:A,"华南区",C:C,"转账")
=SUMPRODUCT((A2:A999="华南区")*(C2:C999="转账"),B2:B999)
=SUMPRODUCT((A2:A999="华南区")*(C2:C999="转账"))
微信扫一扫加关注,Office自学网官方微信公众号,
专注分享软件安装和视频教程,让你一号在手,办公无忧!