Hi
If I understand the problem correctly, you have store names in column C
and your "X" in column AB
Try
=SUMPRODUCT(--($C$3:$C$1500="Store"),--($AB3:AB1500="X"))
Where Store is the store name you are looking for.
--
Regards

Roger Govier


"reno" wrote in message
...
i think i have seen the answer here before...
have ss 1500rx29c of zipcode data, i do a calculation and place an "X"
r28
for each row that meets the criteria (say 25 mi. radius)
the problem...
there are are 1 column that list one store in the zip code, i want to
count
all instances of in R3C3...n where the corresponding row in col28 =
"X"

thanks