SUMPRODUCT

Purpose

Multiplies corresponding values in two or more ranges and then adds the results.

Syntax

=SUMPRODUCT(array1,array2,…)

Example — Sales Calculation

Product

Quantity

Price

Keyboard

10

800

Mouse

20

500

Monitor

5

8500

Printer

3

12000

Formula:

=SUMPRODUCT(B2:B5,C2:C5)

Calculation:

  • Keyboard → 10 × 800 = 8,000
  • Mouse → 20 × 500 = 10,000
  • Monitor → 5 × 8,500 = 42,500
  • Printer → 3 × 12,000 = 36,000

Total Sales = ₹96,500

Real-World Uses

  • Sales calculations
  • Inventory valuation
  • Weighted averages
  • Budget calculations
  • Quantity × Price analysis

Practice

Create an inventory valuation sheet using SUMPRODUCT.

PreviousNext