Secrets of the SUMPRODUCT function ➤ Excel Functions

Опубликовано: 12 Июль 2026
на канале: Андрей Сухов

7,325

347

🚀 New course "Excel for Work":    • Excel с нуля за 1,5 часа | Бесплатный курс...

The SUMPRODUCT function is undeservedly forgotten by many users, even though before the advent of dynamic arrays, it could be used to solve quite complex problems. This means that this function is still relevant in Excel 2019 and older versions. Moreover, in some situations, it can replace array formulas, which many users ignore due to their rather complex logic.

CONTENTS
00:00 | Introduction
00:24 | SUMPRODUCT Function Syntax
00:54 | Cash Receipt
01:28 | Calculating by Criteria
03:47 | Summation by Criteria

Video on this topic:
► Array Formula:    • Формулы массивов ➤ Excel для Продвинутых
► Dynamic Arrays:    • Динамические массивы ➤ Инструменты Excel
► Logic in Excel:    • Логические операторы И (*) и ИЛИ (+) в фор...
► COUNTIF Function:    • Функции СЧЁТЕСЛИ и СЧЁТЕСЛИМН в Excel ➤ Ра...
► SUMIF Function:    • Функции СУММЕСЛИ и СУММЕСЛИМН в Excel ➤ Ра...

Additional Materials:
➤ Download the example file: https://disk.yandex.ru/d/Y57Uv_m1Lfb59Q
➤ Text version: https://dzen.ru/a/ZmMBTwtRFmZISufi

★ Author's books and courses: https://andreysukhov.ru/shop
★ Telegram: https://t.me/excelmate

#Excel