4.计算统计函数

1.
=SUMPRODUCT(R2:R3,S2:S3)
2.
=COUNT(S:S)
3.
=MAX(S2:S11)
=MIN(S2:S11)
4.
=RANK(S5,S2:S5)
5.
=AVERAGEA(R2:R9)
6.
=QUARTILE(R2:R5,0)
7.
=STDEV(S2:S8)
8.
=INT()
=ROUND()
9.
=COUNTIFS(R2:R14,">10",T2:T14,"毕业生")
=SUMIF(T:T,"=应届毕业生",R:R)