J

#### JCarlos

throughly.

I work for a high school and I have an excel file with grade data for each

student. I want to find out what is the average grade for the male population

and the average grade for the female population for each subject.

1A B C D E

2Jones M 75 86 78

3James M 88 90 67

4Jared F 77 80 85

5John F 65 55 60

B=gender; C=English Grade; D=Math Grade; E=Science Grade

I want average of the Males and then i want to compare that to the averages

of Females. I tried several variations of the countif and daverage formulas,

but i get the #value! result.

End result would be to see in one cell how many males passed each course and

another cell to show their average. and then below that see how many females

passed the same courses.

Thanks in advance for everyone's help.

JCARLOS