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