1.
=SUMPRODUCT(R2:R3,S2:S3)
2.
=COUNT(S:S)
3.
=MAX(S2:S11)
=MIN(S2:S11)
4.
=RANK(S5,S2:S5
4.计算统计函数
最新推荐文章于 2024-04-23 22:41:04 发布
1.
=SUMPRODUCT(R2:R3,S2:S3)
2.
=COUNT(S:S)
3.
=MAX(S2:S11)
=MIN(S2:S11)
4.
=RANK(S5,S2:S5