Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604

Download Excel File: https://ift.tt/2V7jVz9
Learn how to add annual salaries for all employees in a large company live in King County using a “Lookup Adding” formula that uses SUMIFS function, a function argument array operation and the SUM Function. This complicated problem is solved with a simple formula.

View on YouTube