I'm sure there's another way, but try this:
=COUNT(H3:H109)-COUNTIF(H3:H109,"<=.74")-COUNTIF(H3:H109,"=.85")
"Tkshowers" wrote:
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.
|