EXCEL中怎么在高级筛选后计数?

=SUMPRODUCT((A$2:A$20=1)*(B$2:B$20=2))=SUMPRODUCT((A$2:A$20=1)*(B$2:B$20=1))=SUMPRODUCT((A$2:A$20=1)*(B$2:B$20=))

=SUMPRODUCT((A$2:A$20=2)*(B$2:B$20=2))=SUMPRODUCT((A$2:A$20=2)*(B$2:B$20=1))=SUMPRODUCT((A$2:A$20=2)*(B$2:B$20=))