| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Correct Count
I'm trying to count the number of names that fall with in a certain alpha
range and numerical range. I can do one or the other but can't seem to do both. Let's say in column B, I have 20 names ranging from A to Zachary and in column E, I have numerical values ranging from 1 to 60. I want to count the number of names that fall between A & Jackson and 11 to 20. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Correct #N/A Value | Excel Worksheet Functions | |||
| Formula required to get the correct count. | Excel Discussion (Misc queries) | |||
| Formula required to get the correct count. | Excel Discussion (Misc queries) | |||
| Not sure if count is the correct formula... Excel 2002 | Excel Worksheet Functions | |||
| If with AND - Is this correct? | Excel Worksheet Functions | |||
Threaded Mode
