Hi,

Assuming the same layout as Biff, in 2007:

=COUNTIFS(A1:A20,"="&G1,A1:A20,"<="&H1,E1:E20,"= "&I1,E1:E20,"<="&J1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"GAIDEN" wrote:

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.