若数据在A1到C100的矩形区域内在D列中输入=countif(">50",A1:C100)-countif(">=100",a1:C100)
=SUMPRODUCT((A1:A100>=50)*(A1:A100<=100))
=COUNTIFS(统计区域,">50",统计区域,"<100")
