Sum of cells with multiple text
 

I have two columns, one is a city and one is the square footage in that city.
I need to sum the square footage based on the name of the city.
However, for central area there are several cities included.
For instance, Trinton, Temple Terrace and Carrollwood are all in central
area and have different square footages but I need to add them all in one
cell. I can't seem to figure out the formula.

Sum of cells with multiple text
 

If you want just Trinton (Trenton???), you could use:

=sumif(a1:a10,"trinton",b1:b10)

If you want trinton and temple terrace as a combined total:

=sum(sumif(a1:a10,{"trinton","temple terrace"},b1:b10))

You may want to add a field that would categorize each city.

Build a table on another sheet with city names in column A and area in column B.

Then you could use =vlookup() to return the area for each city.

Then either use data|pivotable, data|subtotals, or even a bunch of =sumif()'s to
total them.

D. Handa wrote:

I have two columns, one is a city and one is the square footage in that city.
I need to sum the square footage based on the name of the city.
However, for central area there are several cities included.
For instance, Trinton, Temple Terrace and Carrollwood are all in central
area and have different square footages but I need to add them all in one
cell. I can't seem to figure out the formula.

--

Dave Peterson