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

#### CONTENTS

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

### generalized STEPS TO USE FLOOR function

- USE THE FUNCTION
- SUMPRODUCT(“FIRST ARRAY”,”SECOND ARRAY”…)
- Press ENTER and the result will appear.

OTHER WAYS TO REACH THIS ARTICLE

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

YOU MAY LIKE

- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.