=SUMPRODUCT((B1:B4="Carter Middle
School")*A1:A4)/SUMPRODUCT(--(B1:B4="Carter Middle School"))

"Penny" wrote in message
...
I have two columns of data. I want to know the average GPA of only those
students at Carter Middle School. Help?

GPA(COL A) School (COL H)
3.3 Carter Middle School
2.3 Carter Middle School
2.8 Centennial
4.0 Carter Middle School