在excel里用countif函数怎样统计90分至99分这个区间里的人数？

=countif(a1:a100,">90")-countif(a1:a100,">99") 或者 =SUM(COUNTIF(A1:A100,{">90",">=99"})*{1,-1}) 统计A1:A100区域的。不包括90和99