æ³è¦ç¨excelæ±å¹³åå¼ï¼å¯ä»¥æç §ä»¥ä¸æ¥éª¤è¿è¡æä½ï¼
æä½è®¾å¤ï¼èæ³Thinkpadã
æä½ç³»ç»ï¼win10ä¸ä¸çã
æä½è½¯ä»¶ï¼excelã
1ãé¦å æå¼excelè¡¨æ ¼ï¼å ¨ééè¦æ±å¹³åå¼çåå æ ¼ã
2ãç¶åç¹å»å¼å§é¡µé¢å¤çèªå¨æ±ååæ¹çç®å¤´ã
3ãæ¥çå¨ä¸æèåæ ä¸ï¼ç¹å»å¹³åå¼é项å³å¯ã
4ãæ使è¾å
¥å
¬å¼=AVERAGE(A2:A7)ã
å¤æ¡ä»¶æ±å¹³åå¼å½æ°ï¼
AVERAGEIFSå½æ°ï¼=AVERAGEIFSï¼æ±å¹³åå¼åºåï¼æ¡ä»¶åºå1ï¼æ¡ä»¶1ï¼æ¡ä»¶åºå2ï¼æ¡ä»¶2.....æ¡ä»¶åºånï¼æ¡ä»¶nï¼ï¼æå®åºåå åæ¶æ»¡è¶³å¤ä¸ªæ¡ä»¶çå¼è¿è¡æ±å¹³åå¼ã
è¯æ³ç»æï¼=AVERAGEIFSï¼æ±å¹³åå¼åºåï¼æ¡ä»¶åºå1ï¼æ¡ä»¶1ï¼æ¡ä»¶åºå2ï¼æ¡ä»¶2.....æ¡ä»¶åºånï¼æ¡ä»¶nï¼ã
ç®çä½ç¨ï¼å¯¹æå®åºåå åæ¶æ»¡è¶³å¤ä¸ªæ¡ä»¶çå¼è¿è¡æ±å¹³åå¼ã