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.
Mastering Excel: SUMPRODUCT
📄 Viewing lite version
Full site ›
⌛ 🇫🇷 France pricing being fetched…
Prices will appear once fetched — usually within a few minutes.
View in:
🇺🇸 USA