SUMPRODUCT multiplies corresponding values and then adds the results.

Syntax

=SUMPRODUCT(array1,array2,…)

Example

Product	Quantity	Price
Keyboard	5	800
Mouse	10	500
Monitor	3	8500

Formula:

=SUMPRODUCT(B2:B4,C2:C4)

Calculation:

• 5 × 800 = 4,000
• 10 × 500 = 5,000
• 3 × 8,500 = 25,500

Total = ₹34,500

Conditional SUMPRODUCT

It can also perform condition-based calculations.

Example:

=SUMPRODUCT((B2:B10=”North”)*(C2:C10))

This can total values corresponding to North-region records.