I have an array of numbers, each number having a tag associated to it in a different column.
I need to sum up the numbers in the array for which the tag is included in a different array that lists the tags which are allowed to be summed up.

=SUMPRODUCT(B1:B7, COUNTIF(A1:A7,A10:A12))

Here a simplified example:

[![example](https://i.stack.imgur.com/V4hoa.png)](https://i.stack.imgur.com/V4hoa.png)

The output should be 400 (since only Prod A and Prod B are the list a10:a12)

Any hint? Is in Google Sheet. Have tried to combine sumproduct and countif but problem with non matching array sizes. And am not a wiz... Thank you much in advance!