Relating Text to Values and Selecting Specific Rows

Hi, a little new to Excel and the site so don't hesitate to ask if my explanation is a bit confusing.

I have two columns that relate two panels together which are in A and B. These columns contain, in text form, circuit numbers (ex. 6. 10; 5. 13,5. 15) where 6. 10 is panel 6 circuit 10 and 5. 13,5. 15 is panel 15 circuit 13 and 15 (14 not included). I have a list on the same sheet of all of the circuit numbers (col H) in the form of 5.13 as a number and associated phases A,B, and C (col K,L,M) showing amperage numbers. (Please refer to the attachment for clarification; I have omitted information just to show an example)

I need to write a function that selects the appropriate circuit number(s) in row H from row A (i.e. find circuits 13 and 15 for panel 5 row H when it says 5. 13,5. 15) and put the sum of the associated phase number from rows K,L,M into columns C,D,E respectively. Columns A and B may vary while H will remain the constant.

For example: in row 11 on the attachment, I will need it to find the sum of the A, B, and C phases for 6.9, 6.11, and 6.13 and put that sum into the associated phases in cols. C, D, and E. C11, D11, and E11 would then read 0, 3.3, 3.3 respectively.

I then need to take the add up of all of the values in columns C, D, and E for the panel number (first number) in column B and put sum into a single cell (which is C24, D24, and E24 in the example). So in the example C3-6, C8, and C11 will need to be added and put into C24 as in column B all the text begins with "5".

Thanks for any help! Sorry if it was long winded and confusing.