Apple Numbers, matching string variations in a SUMIFS function I'm using a SUMIFS function to get values from a column in another table depending on if they have a certain string in a corresponding memo column. I'd like to be able to check for a few variations on the string, i.e. 

SUMIFS(Amount-column, Memo-column, "this-string*"||"that-string*")


Anyone know how to do this?
Sorry to bring bad news, but there simply is no suitable formula, in-place ORing, or list comparison of that type in Numbers.

Of the common workarounds for similar spreadsheet problems, I find the "helper column" approach to be the most straightforward and maintainable. Create a new column to calculate whether or not that row should count in the later summing. The helper column can then be the condition source in your sumif formula, and hidden.

For example, helper-column cell D2 could be:
OR(  IFERROR(SEARCH("This*",C2),FALSE)  ,  IFERROR(SEARCH("That*",C2),FALSE)  )
and after populating that down the rows, your count formula could be:
SUMIF(helper-column,helper-column,Amount-column)