Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/02/xlookup-return-sum-of-all-matches.xlsx

In this Microsoft Excel video tutorial I demonstrate how to calculate a sum of all matches. You might be trying to do this using XLOOKUP, but this is not always the best method. The video explores three completely different scenarios where you need to sum all matches. Each scenario is best served with a different set of functions.

Table of Contents:

00:00 - Introduction
00:18 - Example 1 SUM FILTER or SUMIF
02:25 - Example 2 SUM XLOOKUP
04:19 - Example 3: SUM SUMIF or SUMPRODUCT SUMIF
------------------------