deepcalc
DocsSUMPRODUCT

SUMPRODUCT

View as markdown/docs/functions/sumproduct.md Ask Claude about this pageOpens Claude with this page's address

Returns sum of products of array components.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=SUMPRODUCT(A1:A3, B1:B3)
AB
1 102
2 204
3 306
Result 280

Syntax

SUMPRODUCT(array…)
array…
range required

Errors

#VALUE!
=SUMPRODUCT(A1:A3,B1:B2)
ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.