Countif?

[reno]

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

 

[Roger Govier]

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.

 

[reno]

i'll give it a try, but suspect i will have to use helper columns here to get
the results ii'm looking for.

for a fuller explanation...i have 1500 zipcodes in indiana, i have a listing
of 5 different stores (wal-marts etc) by zipcode, then i input an indiana zip
code and XL calculates the distances between the input and all the rest of
the 1499 zipcodes, it then and places an "X" in columns for 5,10,15,20,25
mile radius. there are 5 columns of store headings, W-mart, etc., so each
zip has 6 possibliities, from none, to 1 of each of the five stores.

i am looking for a total columns(s) that counts the number of say W-marts
within 25 miles of zipcode XXXXX, any zip w/in 25 mi radius would have an "X"
in the column, so my count or sum would be:
count/sum each of the 5 stores that has an "X" as being w/in 25 miles