Mastering Excel: SUMPRODUCT

This Excel lesson covers the use of SUMPRODUCT. This formula, in its simplest form, mirrors the functionality of SUMIFS. However, I delve a bit deeper into how to use it so you understand that it is more powerful it is than SUMIFS. It really is a mini-query in a single cell.

I will also cover how to use SUMPRODUCT to do achieve functionality not supported by any other formula in Excel. You will earn how to write a formula that returns the last item from a list. Think of it as a VLOOKUP from the bottom of the list. Yup, SUMPRODUCT can do that.