Image: 200dgr/Shutterstock. Applying multiple criteria against different columns to filter the data set in Microsoft Excel sounds difficult but it really isn’t as hard as it sounds.

1] Using the AND operation with multiple criteria. While the AND function requires all the criteria to be True to have the row included in the filter result, the OR function needs at least one of ...

How to Count Multiple Criteria in Excel 2003. ... If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead.