0
It takes two or more sets of numbers, multiplies corresponding ones and adds the total. Each set is known as an array and must have the same amount of values. You can use cell references or actual values, though each array would be in enclosed in braces, as in the following example. The result would be 1 x 3 plus 2 x 4 plus 8 x 5 which is 3 + 8 + 40 and so the result would be 51.
=SUMPRODUCT({1,2,8},{3,4,5})
It could also be done with cell ranges like:
=SUMPRODUCT(A2:A4,B2:B4)
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
How do you calculate a weighted average in Excel?
The easiest way is to use sumproduct in Excel. Sumproduct takes two (or more) lists of the same size and multiplies the corresponding values in each list; then adds the product. See related links for an easy to read tutorial on how to calculate weighted averages in Excel.
What is SUmProduct in Excel mean?
SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.SUMPRODUCT takes pairs of numbers and multiplies them together and then adds the totals of the multiplications. Say you had the values 6, 4, 12 and 5 in the cells from A2 to A5 and 8, 12, 7 and 10 in the cells from B2 to B5. The following function would take each corresponding value in the two columns and multiply them by each other.=SUMPRODUCT(A2:A5,B2:B5)The result would be 230.
What is the step function of Microsoft Excel?
There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.
A formula prewritten by excel is called?
Function
Does the uplookvert function in Excel exist?
There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.
In excel 2013 where are the various function categories stored on the Ribbon?
In Excel Where are the various function categories stored on the Ribbon?
What is the function of percentage in micro-soft Excel?
functions of excel
An If function within an if function in Excel is called what?
A nested if.
How does the trig function ACOS work in Excel?
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
How do you make a box plot in Excel?
Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.
What is a function reference in Excel?
A function can reference cells or named ranges in the function.
Can you enter a function in Excel using autocomplete?
You can use the clipboard in Excel. It is a facility as opposed to a traditional function, like the SUM function or AVERAGE or MAX and other functions that are built in to Excel.
