The teacher is trying to figure out Tom's average from his tests. What is the correct way to determine Tom's average?
GRADE
NAME
100 tom
94 phil
67 janet
58 julio
81 tom
97 sabrina
86 janet
92 tom
62 sabrina
59 mario
100 tom
91 tom
89 janet
72 mario
66 mario
91 phil
The teacher is trying to figure out Tom's average from his tests. What is the correct way to determine Tom's average?
=IF(C3:C18="tom", "average","")
=AVERAGE(B3:B18, "tom")
=AVERAGEIF(B3:B18, "tom", C3:C18)
=AVERAGEIF(C3:C18,"tom", B3:B18)