Count how many cells have values that meet multiple criteria

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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
 
Back
Top