Search multiple cells for various names and sum up the according values

Hello, I am looking for a way/function to find all cells in a column containing certain strings(morrison, apple). The numbers in the cells next to such strings should be summed up and the total returned.

I was thinking of doing it with an if-function, but im relatively new to functions/coding so I would appreciate any help to find the most efficient solution.

Best
Milow

Hallo

=SUMIF($A$2:$A$8;".*(morrison|apple).*";$B$2:$B$8)

2 Likes

English version screenshot:
imagen

And a bit different formula for G2 and down cells:
=SUMIF($A$2:$A$8;".*"&E2&".*";$B$2:$B$8)

2 Likes