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

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.