View Single Post
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

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.