Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603

Download Excel File: https://ift.tt/2V7jVz9
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.

View on YouTube