Sumif to find a single word in a cell without using wildcard

[kiteman]

I have a group of cells on a tab with a list of cities and states, multiple cities and multiple states span down this column. for instance column A on this tab is

Atlanta, Georgia
Savannah, Georgia
Augusta Georgia

they have a corresponding column with a number of users in each city. I also have a second tab with a list of all the states in one column, and a corresponding column on that tab with total users per state. it's basically just a roll-up from the previous tab.

So I need a formula that can sumif the first city/state tab to see if it has the word "Georgia" in a cell and show the total for all the cities in Georgia on this second tab. The problem with using the wildcard here is that there are multiple countries involved in this exercise so writing out the wildcard each time would be very time consuming.

Really the sumif is set up perfectly since each tab has a column that does include the state name in it, however one of those tabs has additional words as well. the tab is locked by a client or else I would do a cheap text to columns to separate the city from the state on the first tab.



any help is appreciated!