How to write an EXCEL formula?

Question

excel

Good evening. Tell me how to make a formula with the following task:
There is a column with words, there are with numbers. The following is needed: if there is a WORD in column A from lines 1 to 21 (for example, a car), then a number is taken from the neighboring column B from lines 1 to 21 and added to the rest, where our WORD is. As a result, we get the sum of the cells where the next column contains the word we need. How to implement it? Thank you!

Answer 1

=SUMIF(A:A, "WORD", B:B)