SUMIF & Split Strings

Hello!

If the attached screen shot works:

Aim: In F5 add all values from column B that are linked to 'A' in column A.
In F6 add all values from column B that are linked to 'B' in column A.
In F7 add all values from column B that are linked to 'C' in column A....and so on.



My problem:

In column B I have used =RIGHT( A5, LEN( A5 ) - FIND( " ", A5 ) ) to separate the string from column A, so the SUMIF function returns an empty cell.


If I enter the text manually (without splitting the string) SUMIF works, is there away around this?

All help, greatly appreciated. Thank-you in advance.Screen Shot 2015-01-15 at 7.30.11 pm.png