EXCEL中区间价格带怎么统计？-excel价格统计,excel怎么统计人数

统计A列数据在10－30区间zd数内据的个数
Excel 2007以上版本输容入
=COUNTIFS(A:A,">=10",A:A,"<=30")

Excel 2003以下版本输入
=COUNTIF(A1:A1000,">=10")-COUNTIF(A1:A1000,">30")

Excel 2007以上版来本输自入知
=SUMIFS(C:C,A:A,"A",B:B,">=39",B:B,"<=59")

Excel 2003以下版道本输入
=SUMPRODUCT((A2:A10="A")*)(B2:B10>=39)*(B2:B10<=59)*C2:C10)
=sumproduct((A1:A10000="B类")*(B1:B10000>=60)*(B1:B10000<90)*(C1:C10000))

Excel 2007以上版本输源入zhidao
=SUMIFS(C:C,A:A,"A",B:B,">=39",B:B,"<=59")

Excel 2003以下版本输入
=SUMPRODUCT((A2:A10="A")*)(B2:B10>=39)*(B2:B10<=59)*C2:C10)