最简单的方法是使用Countifs:

The easiest way is to use a Countifs:

=countifs(Sheet1!$A:$A,$A2,Sheet1!$B:$B,"<="&B$1,Sheet1!$B:$B,">="&B$1)