假设我有一张这样的表格
| Interviewer | Interviewee | Score |
-------------------------------------
| Alex | Ben | 5 |
| Carrie | David | 8 |
| Emily | Felicia | 7 |
| Emily | Bill | 2 |
| Alex | Sharon | 9 |
我想创建另一列，其中包含每个面试官的平均分数。例如
| Interviewer | Interviewee | Score | Interviewer Score |
---------------------------------------------------------
| Alex | Ben | 5 | 7 |
| Carrie | David | 8 | 8 |
| Emily | Felicia | 7 | 4.5 |
| Emily | Bill | 2 | 4.5 |
| Alex | Sharon | 9 | 7 |
我该如何做呢？
答案1
=AVERAGEIFS(B$3:B$999,B3,D$3:D$999), place in E3 and copy down.