mercoledì 27 maggio 2015

Mastering Excel: SUMPRODUCT

Mastering Excel: SUMPRODUCT
Contenuto dell'eBook:

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: