函数count.xls

152637485个数个数 54总个数 9=COUNT(B2:B6) =COUNT(D2:D5) =COUNT(B2:B6,D2:D5) 评分 1评分 2评分 3评分 4评分 5评分 6评分 7评分 8 去掉最高分 去掉最低分 平均得分 =MAX(A3:H3) =MIN(A3:H3) =(SUM(A3:H3) -D5-D6)/6 =(SUM(A3:H3) -MAX(A3:H3) -MIN(A3:H3))/(COUNT(A3:H3) -2)计数=1-E5663COUNT(D6:D5677)/5672 % 了解已完成的工作量或未完工作量工号加班 Y0000 Y0002 Y0003 106 Y0004 Y0007 Y0008 68 Y0010 36 Y0011 Y0014 Y0016 82 Y0019 Y0024 Y0029 Y0030 Y0032 110 Y0034 78 Y0038 89 Y0039 98 Y0050 Y0051 30 Y0052 Y0054 Y0058 Y0059 Y0061 Y0066 Y0068 Y0070 82 Y0074 Y0075 68 Y0076 Y0077 Y0080 Y0088 111 Y0093 Y0094 Y0111 Y0118 Y0120 Y0122 67 Y0133 75 Y0144 Y0147 44 Y0148 Y0150 106 Y0153 73 Y0154 Y0157 48 Y0163 Y0168 Y0170 73 Y0171 38 Y0178 139 Y0184 Y0186 Y0190 Y0191 Y0193 Y0195 Y0224 Y0230 63 Y0231 Y0234 Y0239 47 Y0252 54 Y0253 Y0259 46 Y0268 62 Y0273 Y0284 98 Y0285 87 Y0295 74 Y0297 Y0302 13 Y0303 Y0322 Y0329 Y0333 58 Y0334 Y0338 45 Y0345 Y0356 52 Y0357 116 Y0362 8 Y0369 Y0390 Y0391 62 Y0392 19 Y0402 78 Y0405 19 Y0411 Y0413 Y0415 73 Y0424 Y0439 59 Y0448 Y0454 Y0464 Y0467 Y0477 46 Y0482 116 Y0509 Y0514 Y0518 37 Y0522 Y0532 Y0538 Y0556 27 Y0563 33 Y0564 118 Y0565 Y0566 45 Y0575 116 Y0577 26 Y0582 Y0583 71 Y0590 26 Y0591 73 Y0614 78 Y0615 125 Y0620 93 Y0622 87 Y0638 12 Y0640 8 Y0642 41 Y0650 Y0656 Y0657 65 Y0658 Y0661 71 Y0664 Y0683 Y0691 116 Y0693 Y0709 Y0711 127 Y0716 70 Y0733 63 Y0738 Y0750 Y0771 Y0776 Y0780 80 Y0796 17 Y0805 Y0815 127 Y0817 Y0821 Y0836 70 Y0840 92 Y0841 30 Y0846 33 Y0849 45 Y0852 75 Y0853 101 Y0857 Y0859 89 Y0876 81 Y0886 39 Y0888 37 Y0903 76 Y0906 65 Y0908 110 Y0924 26 Y0926