excel

来源:互联网 发布:淘宝网零钱包儿童卡通 编辑:程序博客网 时间:2024/05/29 04:27

=RANK(M49,$M$49:$M$69,1)


=AVERAGE(SUM(B49,C49,D49,E49,F49,G49,H49,I49,J49,K49,)-MIN(B49,C49,D49,E49,F49,G49,H49,I49,J49,K49))/(COUNT(A49:K49))



  1. =SUM(A2:A15)/COUNTIF(A2:A15,">0")

0 0
原创粉丝点击