I have a spreadsheet with keyword search terms in column A, and values of monthly search volume in column B.

How do I SUM all cells in column B, if the corresponding cell in column A contains a specific keyword (ie: “libre”)?

```
-------------------------------------
A | B
-------------------------------------
Keywords | Volume
-------------------------------------
libre office | 7
libre calc | 9
office excel | 5
```

So in the above example my result would return value 16 (7+9), as both “libre office” (val. 7) and “libre calc” (val. 9) contain the text “libre”.