我需要帮助,以便为下面黄色阴影单元格提供答案。我认为这是一个普通的 ifs 函数。我一直得到 DIV/0
在下面的例子中,我尝试获取各州技术人员和学徒的平均测试分数:
A B C D
1 Name Title Location Test score
2 Joe Tech NY 76%
3 Mary Apprentice NY 88%
4 Steve Tech NJ 63%
5 Harry Installer MA 98%
6 Manfred Tech IA 77%
7 Sam Installer NY 84%
8 Steve Apprentice CT 85%
9 Paul Apprentice CT 86%
10 Jenn Installer IA 88%
期望结果:
Average test score for Techs and Apprentices by state:
NY ?
NJ ?
MA ?
IA ?
CT ?