Help! Not sure how to add then show % using cells with text and numbers

[TSitaO]

I need row 25 of my s/s to show the % complete for the columns B through G, by columns and then overall % in column H. Is there a formula that it updates every time I change an item?

 

[TSitaO]

[TABLE="width: 476"]
<colgroup><col width="68" span="7" style="width:51pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 408, colspan: 6"]Respondents[/TD]
[TD="width: 68"][/TD]
[/TR]
[TR]
[TD="class: xl66"]Self[/TD]
[TD="class: xl66"]Mgr[/TD]
[TD="class: xl66"]IM[/TD]
[TD="class: xl66"]Peer[/TD]
[TD="class: xl66"]DR[/TD]
[TD="class: xl66"]Other[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]1 of 3[/TD]
[TD="class: xl67"]0 of 6[/TD]
[TD="class: xl70"]1 of 12[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]1 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]0 of 7[/TD]
[TD="class: xl67"]0 of 10[/TD]
[TD="class: xl67"]0 fo 4[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]2 of 7[/TD]
[TD="class: xl67"]3 of 4[/TD]
[TD="class: xl67"]0 of 8[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]1 of 4[/TD]
[TD="class: xl67"]0 of 3[/TD]
[TD="class: xl67"]1 of 4[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl67"]1 of 5[/TD]
[TD="class: xl67"]1 of 5[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl71, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]1 of 6[/TD]
[TD="class: xl67"]1 of 8[/TD]
[TD="class: xl67"]0 of 8[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl68"]0 of 3[/TD]
[TD="class: xl67"]1 of 6[/TD]
[TD="class: xl67"]3 of 5[/TD]
[TD="class: xl67"]1 0f 6[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]4 of 9[/TD]
[TD="class: xl67"]1 of 3[/TD]
[TD="class: xl67"]1 of 8[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]1 of 14[/TD]
[TD="class: xl67"]0 of 4[/TD]
[TD="class: xl67"]0 of 4[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]1 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl67"]1 of 5[/TD]
[TD="class: xl67"]0 of 3[/TD]
[TD="class: xl67"]2 of 10[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl67"]1 0f 5[/TD]
[TD="class: xl67"]0 of 4[/TD]
[TD="class: xl67"]1 of 8[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl68"]0 of 2[/TD]
[TD="class: xl67"]0 of 6[/TD]
[TD="class: xl67"]0 of 4[/TD]
[TD="class: xl67"]1 of 5[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]0 of 5[/TD]
[TD="class: xl67"]3 of 10[/TD]
[TD="class: xl67"]0 of 6[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]0 of 3[/TD]
[TD="class: xl67"]0 of 10[/TD]
[TD="class: xl67"]0 of 8[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]0 of 11[/TD]
[TD="class: xl67"]0 of 5[/TD]
[TD="class: xl67"]2 of 5[/TD]
[TD="class: xl71"][/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl67"]2 of 5[/TD]
[TD="class: xl67"]3 of 7[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl71, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl67"]0 of 7[/TD]
[TD="class: xl67"]2 of 4[/TD]
[TD="class: xl67"]1 of 4[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl68"]0 of 4[/TD]
[TD="class: xl67"]1 of 6[/TD]
[TD="class: xl67"]2 of 4[/TD]
[TD="class: xl67"]1 of 4[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]0 of 1[/TD]
[TD="class: xl68"]0 of 1[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl68"]1 of 7[/TD]
[TD="class: xl67"]2 of 4[/TD]
[TD="class: xl67"]0 of 3[/TD]
[TD="class: xl71, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl73"]Total[/TD]
[/TR]
</tbody>[/TABLE]