| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
"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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
| Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
| other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Linear Mode
