Add #, ignore text, in specific cells (not columns) plus percentages

[MrSuperConfused]

I have 11 cells to add that contain text and numbers. I only want to add the numbers, and if possible insert the sum into a cell that also contains text.

My other problem is creating a percentage using those 11 cells divided by 11 corresponding cells with only numbers to get the percentage in the another cell that also contains text.

 

[Scott Huish]

Can you provide some sample data and expected results?

 

[MrSuperConfused]

Office 2013

Cells contain: “T: #”. I have to add those 11 cells into a cell that I want to contain, “T: answer” the answer should total 180.

For the percentages. It’s “U: #” divided by “#” and answer goes in cell containing “text - %”.

 

[MrSuperConfused]

Not sure where all those Âs came from, just ignore them.

 

[mikerickson]

What do you want the result to be if these are the entries

12
AT-14
Sam_23at57
87

 

[MrSuperConfused]

I have no idea seeing as how none of those are applicable.
Say all 11 cells contain T: 7.
No cells are next to each other in columns or rows.
I want to add all 11 cells and put the answer in a totals area.
I want the answer to look like T: 77

 

[MrSuperConfused]

Now for the percentages.

Each T and U cell has a corresponding total cell that does not contain a letter.

Example cell E4, U: 12, divided by cell C4, 19. (Or however excel does the math for percentages)

And insert the answer in cell B3 which contains TITLE - 63%

 

[Scott Huish]

If it's just a single letter followed by a colon, then a number. Something like this for the sum.

=SUM(IF(MID(A1:A100,2,1)=":",--MID(A1:A100,3,255)))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.


Your division example:
="TITLE - "&TEXT(IF(MID(E12,2,1)=":",--(MID(E12,3,255)/C4),""),"0%")

 

[MrSuperConfused]

Neither are working

 

[mikerickson]

Can you post an example of some sample data and the desired result.