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.
Per maggiori informazioni: l'eBook "Mastering Excel: SUMPRODUCT" di Mark Moore è in vendita in formato Kindle su Amazon.it al prezzo di Euro 2,99
.
Nessun commento:
Posta un commento