Countif and sum adjacent cells

Hi there

I have a set of data. Each topic/subject has multiple entries. Adjacent to each topic is a number.

I need the countif formula to look for all 'common' words and to sum all the figures in the adjacent cells:

countif.xlsx

Hello!

I did matrix function to check if it has the words "BMW" / "CITROEN" / "FORD" / "RENAULT"

=SUM((NOT(ISERR(SEARCH(D$2,$A$2:$A$11)))*1*$B$2:$B$11))

Where D$2 is BMW, D$3 is Citroen, D$4 is Ford and D$5 is Renault

Check the workbook: countif.xlsx

Try SUMIF

=SUMIF($A$2:$A$11,"BMW*",$B$2:$B$11)

If you want to put BMW into a cell reference, then
=SUMIF($A$2:$A$11,G2&"*",$B$2:$B$11)
G2 = BMW

Much better @Jonmo1's way