Multiple Arguements Using COUNTIF

S

switchgrass

I'm trying to count the number of numbers in a column that fall within
two arguements.

Example: =COUNTIF(A1:A25),">18","=<23.99"

What is the proper way to come up with the desired result?:confused:
 
P

Peo Sjoblom

One way

=COUNTIF(A1:A25,">18")-COUNTIF(A1:A25,">23.99")

another

=SUMPRODUCT(--(A1:A25>18),--(A1:A25<=23.99))
 
Top