2] Using the OR operation with multiple criteria. The OR operation is fulfilled when any one or more than one criteria are fulfilled. So, for example, if you want to find out how many employees ...

To accomplish an AND across multiple columns, we’ll use the * symbol, which is similar to the AND() function, but AND() doesn’t work as you might expect when combined with FILTER().

The COUNTIFS function will search through cell locations in multiple ranges and return a count of "1" for every time all the ranges meet your criteria in the same cell location.