 PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

# EXCEL FUNCTIONS-SUMPRODUCT

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

## 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 height
So 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.

• ## WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

• EXCEL
• JAVASCRIPT
• MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com