Mastering Excel: SUMPRODUCT Mark Moore

ISBN:

Published:

Kindle Edition

27 pages


Description

Mastering Excel: SUMPRODUCT  by  Mark Moore

Mastering Excel: SUMPRODUCT by Mark Moore
| Kindle Edition | PDF, EPUB, FB2, DjVu, talking book, mp3, RTF | 27 pages | ISBN: | 6.77 Mb

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 aMoreThis 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.



Enter answer





Related Archive Books



Related Books


Comments

Comments for "Mastering Excel: SUMPRODUCT":


magazynkarton.pl

©2012-2015 | DMCA | Contact us