SUMPRODUCT

About This Document
The Gnumeric Manual, version 1.8
- Welcome!
- How to Use this Manual
- A Quick Introduction
- Gnumeric Elements
- Working with Data
- Advanced Analysis
- Graphics: Plots, Images, Widgets, and Drawings
- Configuring Gnumeric
- Working with Files
- Printing
- Getting More Help
- Reporting a Problem
- Extending Gnumeric
- Function Reference
  - Bitwise Operations
  - Complex
  - Database
  - Date/Time
  - Engineering
  - Erlang
  - Finance
  - Gnumeric
  - Information
  - Logic
  - Lookup
  - Mathematics
    
    ABS
    
    ACOS
    
    ACOSH
    
    ASIN
    
    ASINH
    
    ATAN
    
    ATAN2
    
    ATANH
    
    BETA
    
    BETALN
    
    CEIL
    
    CEILING
    
    COMBIN
    
    COS
    
    COSH
    
    COUNTIF
    
    DEGREES
    
    EVEN
    
    EXP
    
    EXPM1
    
    FACT
    
    FACTDOUBLE
    
    FIB
    
    FLOOR
    
    G_PRODUCT
    
    GCD
    
    HYPOT
    
    INT
    
    LCM
    
    LN
    
    LN1P
    
    LOG
    
    LOG10
    
    LOG2
    
    MDETERM
    
    MINVERSE
    
    MMULT
    
    MOD
    
    MROUND
    
    MULTINOMIAL
    
    ODD
    
    PI
    
    POWER
    
    PRODUCT
    
    QUOTIENT
    
    RADIANS
    
    ROMAN
    
    ROUND
    
    ROUNDDOWN
    
    ROUNDUP
    
    SERIESSUM
    
    SIGN
    
    SIN
    
    SINH
    
    SQRT
    
    SQRTPI
    
    SUM
    
    SUMA
    
    SUMIF
    
    SUMPRODUCT
    
    SUMSQ
    
    SUMX2MY2
    
    SUMX2PY2
    
    SUMXMY2
    
    TAN
    
    TANH
    
    TRUNC
  - Number Theory
  - Random Numbers
  - Statistics
  - String
- Keybinding Reference

SUMPRODUCT —

SUMPRODUCT()

Multiplies corresponding data entries in the given arrays or ranges, and then returns the sum of those products.

SUM, PRODUCT, G_PRODUCT.