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.

LENGTHBREADTHHEIGHT
123234
222420
292627
232327
282724
272529
282123
262124
USING SUMPRODUCT FUNCTION IN EXCEL

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.