Count formulas

[Barb]

I am trying to do a set of 3 counts between 1-100. Under
80 Between 80-90 and 90+.
I have 2 formulas that are working and can't seem to
figure the 3rd, could anyone help?
1st =COUNTIF(G4:K22,">89.99") 2nd =COUNTIF
(G4:K22,"<79.99") It is the middle one that I am not able
to figure out.

 

[Don Guillett]

count all -those two or
=sumproduct((g4:k22>=80)*(f4:k22<90))

 

[Ken Wright]

You can also just combine them:-

=COUNTIF(G4:K22,">=80.00")-COUNTIF(G4:K22,">90.00")