EXCEL中，有好多百分比的数，怎么统计1%-10%有多少个

Question

如题所述

Answer 1

如果数据在A列：
=COUNTIFS(A:A,">1%",A:A,"<10%")

Answer 2

可以用筛选，或者数据透视，

Answer 3

=countifs(a:a,">=1%",a:a,"<=10%")