How to sum all cells in column B where column A in the same row contains a specific string of text?

I have a spreadsheet with names in column A and numerical responses in columns B, C, etc. I want to make it so that if, in a given row, column A contains a specific name (say, "Bob"), then the numerical value in column B in that same row will be added.

Basically, I want the sum of all the rows in column b for which column a contains "Bob".

I can't just sort by column a because sometimes it will contain multiple names per cell (ie Susan, Bob), and I need the equivalent numerical value to be added to both Bob and Susan's total.

I've tried google searching this but I can't figure out how to specify same row but different column. I know I could probably do this with what I know already using just like... a lengthy chain of conditionals, but last time I tried that I ended up with an excel file that crashes my computer every time I try to open it, so I was hoping there's a better option.

This is Version 16.85 on a Mac btw.