Count how many cells have values that meet multiple criteria

[Mike]

Well here I go again. I am trying to do a countif function
but would like to have more than one criteria met. An
example would be to count a group of cells and return a
count of how many are = to 100 and > 100 and < 200.

Thanks in advance,

Mike

 

[Dan E]

Mike,

=COUNTIF(B14:B41,">=100") - COUNTIF(B14:B41,">=200")
will return that range.
Note, >= 100 as you specified
you specified < 200 so you need to subtract those >= 200

Dan E