COUNTIF(...)+COUNTIF(...)
Filtering Columns for a given criteria
Used Functions
Category: Statistical
Counts the number of cells within a range that meet the given criteria
Syntax
COUNTIF(range, criteria)
Practice COUNTIF Formula at Sheetzoom
COUNTIF formula at Microsoft help
0
For filtering columns for a couple for criteria, we will use the COUNTIF function twice so that each countif can check for the criteria independently and result will be displayed in the helper column, that column will be filtered for the value of two to get the desired results.