| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| How can I change text to proper text in multiple cells. | Excel Discussion (Misc queries) | |||
| How to input additional text to multiple of existing cells that has text | Excel Worksheet Functions | |||
| Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
Threaded Mode
