Download Excel File: Learn how to count how many employees in a large company live in King County using a “Lookup Counting” formula that uses COUNTIFS function, a function argument array operation and the SUM Function. This complicated problem is solved with a simple formula.