Hi,

I am struggling to get SUMIF working when a any text from a set of text values are in a cell.

1.JPG

I want to write formula which
includes SUM IF based on
either iPHone or Galaxy but NOT SIM

Can you help me please I have tried many combinations but no luck.

Thanks a bunch