I have a group of stores operating in different cities and counties within a
state and need a function to find the total sales for each respective city
and county. Column B (only unique column) is Dealer Name, C is City name, D
is city code, F is County Name, G is County Code, and I is Store Sales.
The city/county codes are in the format of "00-00" where the first set of
numbers denotes the county and the second set the city. For example, the
city of Conway, which is in Faulkner County is denoted by "23-01" whereas the
city of Mayflower in the same county is denoted by "23-02."

I've tried several IF functions but nothing that has really made any
headway. Anyone have a suggestion?