ä¸ç¥éä½ å°åºéè¦æä¹ä¸ªåææ³ï¼åè以ä¸å½æ°ï¼
1ãcountif ç»è®¡ç¬¦åæ¡ä»¶äººæ°ï¼æ¯å¦ =COUNTIF(C1:C22,">80") ç»è®¡c1å°22ä¸å¤§äº80åçï¼å¦æéè¦å¤ç§ç®ç»è®¡ï¼å¯ä»¥ä½¿ç¨countis å½æ°ï¼ï¼
2ãAVERAGE ãAVERAGEifãAVERAGEifs çç¨æ¥æ±å¹³åæ°ï¼
3ãcount ç»è®¡æ°éï¼æ¯å¦ç»è®¡åè人æ°ï¼
4ãrank æå
5ãsumifãsumifs æ¡ä»¶æ±åï¼æ¯å¦å¯ä»¥åçãåç»ãåæ§å«æ±æ»åçï¼
6ãMEDIAN æ±ä¸é´å¼ ãmax æå¤§å¼ ãmin æå°å¼ ã
7ãlargeæ大çæå 个å¼ãsmall æå°çæå 个å¼
温馨提示:答案为网友推荐,仅供参考