2019版本office中Excel怎么用分类汇总求每个班的各科的平均成绩
2019ççExcelåç±»æ±æ»æ±å¹³å:å设æ°æ®æºå¨A1:E16åå
æ ¼åºåï¼åç±»æ±æ»æ±å¹³åå¼ï¼å¦ä¸:
éæ©A1:E16åå
æ ¼åºå;ä¾æ¬¡åå»âæ°æ®âé项å¡-âåç±»æ±æ»â;å¨å¼¹åºçâåç±»æ±æ»â对è¯æ¡ä¸çâåç±»å段âéæ©âç级âï¼âæ±æ»æ¹å¼âéæ©âå¹³åå¼âï¼âéå®æ±æ»é¡¹âå¾éå个ç§ç®ï¼åå»âç¡®å®âæé®ã
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b55b319ebc4b74575613568dffc1e178b8215d2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
åç±»æ±æ»è®¾ç½®å¾
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/730e0cf3d7ca7bcb718e4551ae096b63f724a8d3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
æç»ææå¾
温馨提示:答案为网友推荐,仅供参考
第1个回答 2020-11-06
用sumifs配或averageifs