INTRODUCTION
SUMPRODUCT FUNCTION available in Microsoft Office is a very useful function when it comes to find out the sum of corresponding lists in Excel.
It is found under the MATH AND TRIG GROUP of the formulas in MICROSOFT EXCEL.SUMPRODUCT function multiplies the corresponding components of the arrays and returns the sum of these multiplication results.This kind of function is very helpful in finding out the areas, any multiplication of components, mathematical multiplications etc.
PURPOSE OF SUMPRODUCT FUNCTION IN EXCEL
SUMPRODUCT FUNCTION multiplies the corresponding elements of different arrays and returns their sum as the output.
PREREQUISITES TO LEARN SUMPRODUCT FUNCTION
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the MATH AND TRIG terms is an advantage for the use of such formulas.
- Of course, Excel software.
Helpful links for the prerequisites mentioned above What Excel does? How to use formula in Excel?
SYNTAX: SUMPRODUCT FUNCTION
The Syntax of SUMPRODUCT FUNCTION is
=SUMPRODUCT (ARRAY1, ARRAY2……)
ARRAY1,ARRAY2 contains the list of elements , whose components we want to multiply and add.
EXAMPLE:SUMPRODUCT FUNCTION IN EXCEL
DATA SAMPLE
The section demonstrates an example to show the use of SUMPRODUCT FUNCTION in excel.
Three array lists are there and we’ll find out the sum of corresponding elements.
Suppose we have 8 different cubes and the data with us is the breadth , length and height of the cubes.
We need to find out the total volume of all the 8 cubes.
| LENGTH | BREADTH | HEIGHT |
| 12 | 32 | 34 |
| 22 | 24 | 20 |
| 29 | 26 | 27 |
| 23 | 23 | 27 |
| 28 | 27 | 24 |
| 27 | 25 | 29 |
| 28 | 21 | 23 |
| 26 | 21 | 24 |
STEPS TO USE FLOOR FUNCTION-EXAMPLE
STEPS:The three arrays contain the length , breadth and height of the cubes.We know that volume of a cube is given by length x breadth x heightSo it means that we need to find out the multiplication of all the three parameters and then add them.Or, we can find individual volumes and add them.Or, we can use our function SUMPRODUCT to find out the sum of the volumes in one step. The length , breadth and height are given in the arrays, F6:F13,G6:G13 and H6:H13 respectively.The formula used here is =SUMPRODUCT(F6:F13,G6:G13,H6:H13)
GENERALIZED STEPS TO USE FLOOR FUNCTION
HERE ARE THE STEPS TO USE COUNT FUNCTION PLACE YOUR CURSOR IN THE CELL WHERE YOU WANT THE RESULT.
- USE THE FUNCTION
- SUMPRODUCT(“FIRST ARRAY”,”SECOND ARRAY”…)
- Press ENTER and the result will appear.