Welcome! Register Now to Unlock Exclusive Excel TutorialsGet Started
- Exclusive Playlists
- Downloadable Videos
- No Ads!
- Exclusive Templates
Description: SUMPRODUCT. It's a function that can be really useful if you use it the right way. But what does this function do? Well, sumproduct stands for sum product and is used to calculate an array of values in one go. For example, let's say you have two columns with data in them - column A has numbers 1 to 5 while column B has 2s through 6s. If you want to find out how many combinations there are when combining these two columns, then sumproduct would be your answer! Table Of Content: 00:00 Introduction 01:17 SUMPRODUCT Basic Example 03:36 SUMPRODUCT Limitation (Basic) 06:14 SUMPRODUCT Advance Example 09:30 SUMPRODUCT Limitation (Advance) 12:29 SUMPRODUCT Date Criteria 16:00 Conclusion First we need to understand syntax of SUMPRODUCT Function as below; SUMPRODUCT(array, [criteria], [function]) Array: It is a range of cells that you want to calculate. Criteria: This is optional. You can use it to specify conditions under which the function should work. Function: The function can be one of the following - sum, product, max, min or average. Standard benefits: - Quickly find sums or products of any ranges in one go. - sumproduct function is easy to use and understand. - sumproduct function can be used for all sorts of calculations, so you'll always know the answer when someone asks you a difficult question! We can use sumproduct in two ways are Basic and Advanced. Basic sumproduct give us a total number of combinations when we combine multiple columns while advance sumproduct is sum-product with date criteria example. We have to apply the same formula but different conditions which you will see in sumproduct date criteria example. I hope you understand sumproduct function after watching this tutorial video. If you have any questions related to sumproduct then comment me down below i will try my best to answer your questions as soon as possible. Thank You!