Looking for help with VLookup (I think)

From your JPEG file I think this would work if put into L4 and copy down:

=SUMIF($I$6:$I$150,MID(K4,LEN(K4)-1,1),$H$6:$H$150)

Note though that this will only work if your application tools value always ends with a single character value inside brackets. So if you changed 'Word (W)' to 'Word (Wd)' or 'Word - W' it would not work. Somebody will probably have a more efficient solution but that's the only one I can think of.