Try this:

=COUNTIF(range,"1400") - COUNTIF(range,"<1500")

Hope this helps.

Pete

On Aug 26, 9:27*am, T3 wrote:
*say 1400 & <1500 in a range from 1200 to 1600