=SUMPRODUCT(--(H3:H10974%),--(H3:H109<85%))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tkshowers" wrote in message
...
Sorry, some of the posts mention this, but I do not know enough to figure
it
out. I am a teacher and I am trying to collect some data. Please help.

I need a formula to count the number of grades that are greater than 74%
and
less than 85% in the cell range of H3:H109. Any help would be greatly
appreciated.