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]

Neither are working

It does for the sample data you gave. How did it not work?

Excel 2010
	A	B	C	D	E
1	T: 7		77
2	T: 7
3	T: 7	TITLE - 63%
4	T: 7		19
5	T: 7
6	T: 7
7	T: 7
8	T: 7
9	T: 7
10	T: 7
11	T: 7
12					U: 12
Sheet1

Cell Formulas
Range	Formula
B3	="TITLE - "&TEXT(IF(MID(E12,2,1)=":",--(MID(E12,3,255)/C4),""),"0%")
C1	{=SUM(IF(MID(A1:A100,2,1)=":",--MID(A1:A100,3,255)))}
Press CTRL+SHIFT+ENTER to enter array formulas.