Wauvel

Excel like a finance pro.

← The library

Database function

DPRODUCT

Multiplies the values in a table column that match criteria.

Rarely usedDifficulty 1350 · AdvancedUsage rank #325 of 520
Practice · 2 questions →

When to use it

Multiplies the values in a column for rows matching the criteria range.

The shape of it

Syntax
=DPRODUCT(database, field, criteria)

Worked examples

  • One condition

    =DPRODUCT(A1:E11,"Units",H1:H2) → 30

    West units 2 × 3 × 5.

  • AND conditions

    =DPRODUCT(A1:E11,"Units",H1:I2) → 15

    West and Units >2: 3 × 5.

  • Compounding

    =DPRODUCT(A1:E11,"Growth",H1:H2) → 1.12476

    Growth factors for one region compounded.

Worth knowing

  • Compound growth by group is the realistic use.
  • PRODUCT with FILTER does the same in Microsoft 365.
  • Blanks are ignored.

Where it goes wrong

  • A zero in the column makes the product 0.
  • Header mismatches return 0.

Related

DSUMDAVERAGEDCOUNTDCOUNTADGETDMAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.