Sumifs with OR operator text string search in single cell...

Am trying to calculate the total from an multiple parameter sumif but...the process is somewhat complicated by having an OR operator text search and a desire to limit the addition of a new column.

I have no problem evaluating each element of the dataset to a true/false state which I can then sumproduct/sumif(s) etc but again I'm really trying to avoid adding another column to what is already a very large data set.

I feel like I might be missing something fairly obvious about a way to integrate an array function into the calculation of the target value. A simplified example is attached.

TestSheet.xlsx

Thanks for any help.

This works, hadn't considered splitting up the text search like this. Thank you for the help.