Multiple Arguements Using COUNTIF

  • Thread starter Thread starter switchgrass
  • Start date Start date
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:
 
One way

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

another

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