How do I use SUMPRODUCT in Excel?
Use SUMPRODUCT when you want to multiply ranges and sum the results. Enter Array 1, Array 2 in that order, then add optional arguments when needed.
Excel Function
SUMPRODUCT
Returns sum of products of arrays.
SUMPRODUCT(array1, [array2], ...)Arguments
array1
RequiredSpecify a reference range. You can drag or click start/end cells.
array2
OptionalSpecify a reference range. You can drag or click start/end cells.
Practice Preview
Use SUMPRODUCT to multiply Unit Price in column B and Quantity in column C row by row and return the sum. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | 361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | S005 | 150.9 | 6 | 905.4 |
| 7 | ||||
| 8 |
How to Use (Formula)
=SUMPRODUCT(B2:B8, C2:C8)Result
3860.9
Practice This Function
SUMPRODUCT FAQ
Where can I practice SUMPRODUCT?
Use the "Start Function Practice" button to jump straight into SUMPRODUCT drills.
What arguments does SUMPRODUCT use?
The main arguments are Array 1, Array 2. Start with the required ones, then add optional arguments if needed.