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?

"Johbou" wrote:

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?

OK disregard the above question; I've found enough info on this forum on the
same subject. Best regards.