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.

Follow Along Workbooks

If you already have the book and you are looking for the follow along workbooks. Input your information below and I will send it to you in a few minutes. I won’t spam you. I send email tips and tricks every few weeks and I let you know when a new lesson is published. That’s all.

If you don’t see the sign up form below, try disabling any ad blockers. I promise you the form is there.

Enter your name and email below to get your follow along workbook