I would like to count unique values returned by an array after comparing it
with a list. I have an array set up to return the averages of several
students grades including two other conditions i.e "abs" if the student was
absent, "X"
if they left the class or school. here's the formula for that.. works fine

=IF(AND(G5="Abs",H5="Abs"),"ABS ",IF(AND(G5="X",H5="X"),"EXED
",IF(COUNT(G5:AF5)=0," ",(SUM(G5:AF5))/(COUNT(G5:AF5)))))

....and then another to determine if they are male or female students and sum
them up accordingly

=IF(COUNT(AG5:AG45)=0,"
",SUM(($D5:$D45="F")*(AG5:AG45=0),-($D5:$D45="F")*(AG5:AG45="EXED")))

where F = female & EXED= students who no longer belong to the class. This
works fine only if the 1st formula returns number values i.e percentages, but
does not when it returns text i.e the word EXED.

Help. I need to count only the male/female syudents who were absent or have
percentages.