COUNTIF not working

[tom_n_ape]

I am trying to run the COUNTIF function on a range of data as follows:

=COUNTIF(G$19:G$100, ">=" & H19 & "<" & H20)

or, another way to write what I'm trying to do is:

=COUNTIF(G$19:G$100, ">=" & H19 AND G$19:G$100 & "<" & H20)

Neither of the above functions is working the way I need it to. I am
simply trying to find the number of values in the range that fall
within the lower and upper bound: i.e., H19 and H20.

Any help with this would be greatly appreciated.

Thanks,

~tom

 

[Aladin Akyurek]

=COUNTIF(G$19:G$100,">="&H19)-COUNTIF(G$19:G$100,">"&H20)

This yields a count based on an inclusive between.