Use cells to hold your criteria:

G1 = A
H1 = Jackson
I1 = 11
J1 = 20

=SUMPRODUCT(--(A1:A20=G1),--(A1:A20<=H1),--(E1:E20=I1),--(E1:E20<=J1))

--
Biff
Microsoft Excel MVP


"GAIDEN" wrote in message
...
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.