Take the NAs and whatnot out and try one of these:

=SUMPRODUCT(--(B5:B74="F"),--(G5:G74<=59),--(G5:G740))

Or probably better, this, since you might have entries of zero you
actually want to count:

=SUMPRODUCT(--(B5:B74="F"),--(G5:G74<=59),--(G5:G74<""))

Drowning in data wrote:
This formula worked, but it also counted females who didn't have test scores
entered (the cell is blank). Because I am recording the results of several
tests on the same spreadsheet, I only want a tally of the females who have
test scores entered and whose scores fall within the specified ranges. It
seems to be considering a blank cell as a zero score. I tried entering NA in
the cell to designate "does not apply" but then it added the student to those
females scoring above 90%. Any suggestions?

"smartin" wrote:

Can you use this?

=SUMPRODUCT(--(B5:B74="F"),--(G5:G74=61),--(G5:G74<=70))

Drowning in data wrote:
=SUMPRODUCT(--(B5:B74="F"),--(G5:G74<=59))

[snipped]