Summarizing multiple dynamic columns with a formula

ASample.xlsxHi.

I have a spreadsheet that contains 12(x3) columns - one for each month of the year - and I'm desperately looking for a way to summarize them, ie. make 1(x3) column containing the same information and summarizing.

To make it a bit more visual, I'll recreate it a bit in BBCode (but I can't merge the columns here):

January			February			March
Name	Time	%	Name	Time	%	Name	Time	%
A	10	20	A	20	40	B	5	10
B	10	20	C	20	40	D	25	50
C	30	60	D	10	20	E	20	40

What I would like is a formula that creates the following:

A	30
B	15
C	50
D	35
E	20

This serves two purposes:
1) Being able to calculate percentages on a yearly basis; and
2) Creating a graph on those data

Obviously I could do this with static data, but in reality the data is dynamic and I cannot predict the size of the ranges (but I did limit it to 200 rows - from A38:AJ240 to be exact, including the two header rows). I cannot use VBA because of policies so I wonder how to do this with a formula.

Thanks for your advice!

Could you post a sample workbook instead of the table?

Thanks for that! However, some people (myself included) are not able to access third party sites for downloading workbooks. However, this site has an attachment capability. Select "Go Advanced" down below, then select "Manage Attachments" to upload.

Sorry, just back to my computer today. I'm having trouble visualizing what exactly it is you want. Could you incorporate what your expected results should look like into your sample workbook?