Excel VBA

=COUNTIF(Y3:Y212,"=11")

=SUMIF(Y3:Y212,"=11",AA3:AA212)

=SUMPRODUCT((Y3:Y212="11")*(Z3:Z212=Z223))

posted on 2016-06-21 15:43  szllq2000  阅读(137)  评论(0编辑  收藏  举报