One way ...

Put in M1: Carter Middle School
Put in M2: Female

Put in M3, and array-enter (press CTRL+SHIFT+ENTER):
=AVERAGE(IF($H$2:$H$5=M$1,$L$2:$L$5))

M3 will return the mean GPA for "Carter Middle School"

Put in M4, and array-enter (press CTRL+SHIFT+ENTER):
=AVERAGE(IF(($H$2:$H$5=M$1)*($A$2:$A$5=M$2),$L$2:$ L$5))

M4 will return the mean GPA
for "Females" in "Carter Middle School"

Adjust the ranges to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Penny" wrote in message
...
Thanks! Now I am wondering if you could help me with something else?? If
I
use the same data as before but add a column L for GPA. Is there a way
for
me to calculate the mean GPA for those students at Carter Middle School?
Thanks.

Gender (COL A) School (COL H) GPA (COL L)
Male Carter Middle School 3.5
Female Carter Middle School 2.5
Female Centennial 2.5
Female Carter Middle School 3.8