Forum Discussion
Advanced Filters, is it possible colA=("a" OR "b" OR "c") AND colB=("1" OR "2" OR "3") on one row?
Doing some diagnostics of mail delivery failures of messages within several domains all under the same Office 365 tenant. So, looking for messages with domains a.com, b.com, and c.com as part of ...
Let the data be in A:B with headers in A1:B1 and the criteria range I1:I2 with header left blank and this formula in I2:
=SUMPRODUCT(COUNTIFS(A2,{"*@a.com","*@b.com","*@c.com"}))+SUMPRODUCT(COUNTIFS(B2,{"*@a.com","*@b.com","*@c.com"}))=2
The curly braces are used inside the formula and indicate an array syntax. It can replaced with a cell range.
And yet the formula is an array formula because COUNTIFS() expects a single value for the criteria and my formula passes a set of criteria.