I have looked at your sheet and I can't puzzle out what words you are referring to.

But what you probably need to do is something along the line of

=Left(A1;3) which will give you the first three characters of the referenced cell.

Then you need to combine that with a SUMIF function.

/Møller