Hey guys

So I've been looking and searching for anything that could help me, to no avail.

I have columns of text and number combinations. I need excel to check a whole column to see if it contains "FT" in the text, if yes then find the number next to the text and sum it at the bottom.
This is the desired result:

Column A | Column B
FT4
FT2
FT4
SD4
SD3


10 | FT sum
7 | SD sum

Any help would be greatly appreciated

-Alco