Calc: How to AND/OR several text patterns?

[BeOS]

Hi,

How can I AND (or OR) several text patterns in a SUMIFS?

In pseudocode:

SUMIFS(A1:A100, B1:B100, "*FOO*" | "*BAR*" | "*BAZ*")

[mikekaganski]

See my answer to your other question.