Thread: Correct Count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GAIDEN GAIDEN is offline
external usenet poster
 
Posts: 30
Default 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.