have a db of zipcode data, i have macro that once a zipcode is entered, it
uses lookups to return all zipcides within 25 mil radius then orders them in
distance from the reference zip code. One think it does is place and "X" in
column BP9...

One of the fields returned is population.

i have used the Sumif( that sums if "X" in BN9...) then I want to take that
total and call it ttldogpop, then divide each of the individual dogpops with
an "x" for a %.

i am getting circ reference...any ideas? thanks