View Single Post
  #1   Report Post  
Johbou
 
Posts: n/a
Default multiple conditions in COUNTIF (Excel 2000)

I want to count the number of occurences of a specific range in a list of
numbers. I.e. the numbers range from 0 to 24 and I want to count the number
of "hits" that are between 12 and 13. COUNTIF seems the obvious if want to
keep it simple. But it seems COUNTIF can handle only one condition ("12" or
"<13", not both), not allowing "AND" to be part of the criteria. Any
suggestions?