Hi,

can this be done using countif
you have three cities, Toronto (TOR), Calgary (CAL) and Vancouver (VAN) and you have ID tags for sites in those locations.
column 'A' will have the cities, column 'B' will have the formula and column 'C' will have the list of sites.
example
A
Calgary

B
2

C
(DON-CAL 10293 B)
(DON-CAL 104759 C-5)

and so forth

please let me know if you would need a copy of raw data