To find rows that meet multiple criteria in multiple columns, type all of the criteria in the same row of the criteria range.

• 要查找满足“多列中有多个条件”的行,请在条件区域的同一行中键入所有条件。