SUMPRODUCT Formula in Excel
Автор: Excel With Ravi
Загружено: 2018-10-07
Просмотров: 1540
Описание:
This video is part of a series that belongs to my course called Advance Excel formulas.
The classical use of excel SUMPRODUCT function is to do a sum of multiplication. The good thing about SUMPRODUCT is that it can work on arrays of values and it doesn't have to be entered as an array function so no need to do control + shift + enter.
This great thing about SUMPRODUCT, is that it can help solve many more problems in non-obvious ways. It can act as a conditional SUMIFS function or work as a lookup function as INDEX and MATCH does. It can also act as a COUNTIF function.
SUMPRODUCT is also a better SUMIFS, because it can check for OR conditions- which the SUMIFS can't. SUMIFS can only check for AND conditions.
In this video you will see different examples of the SUMPRODUCT function and you will learn how it can save you for unnecessary "workarounds" in your Excel files. It will also show you the SOMPRODUCT formula in slow motion.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
