Prevent auto-escaping characters in structured table reference?

I'm storing a string array in a table column, and then trying to properly reference that literal value in a SUMIFS formula.

The value that I need the reference to evaluate to is: {"*ABC*,*XYZ*"} (because I'm looking for ABC or XYZ anywhere within a string)
If I enter that text in a table cell, the reference to that cell evaluates as "{""*ABC*,*XYZ*""}" giving me extra quotes that screws up my formula.

I've also tried making the table cell text simply *ABC*,*XYZ* and then referring to it as "{"&[@Apps]&"}" however that evaluates to "{*ABC*,*XYZ*}" which is almost right, but the outer quotes & braces are reversed from what I need.

There's got to be a way to do this, but I sure can't seem to figure it out. Thanks!

Hmmm. I don't see how I could adapt the SUMIFS formula to effectively "OR" those values in different cells.

Try

=SUMPRODUCT(SUMIFS(A2:A6,B2:B6,E2:F2))

A2:A6 values to summed

B2:B6 your text

E2 = "*ABC*" (without the quotes)

F2= "*XYZ*" (without the quotes)

I didn't know that specifying a range is equivalent to an array constant. That worked for me, but only after I changed my formula from =SUM(SUMIFS(... to =SUMPRODUCT(SUMIFS(... I have no idea why it wouldn't work using SUM.

Thank you both, shg & JohnTopley!