SUMPRODUCT
Math FormulasMaster SUMPRODUCT for weighted sums, conditional calculations, and array operations. A powerful alternative to SUMIFS.
Syntax
SUMPRODUCT(array1, [array2], [array3], ...)Parameters
array1First array or range
array2, array3Additional arrays to multiply (optional)
Examples
=SUMPRODUCT(A2:A10, B2:B10)Sum of products (weighted sum)
=SUMPRODUCT((A2:A10="Sales")*(B2:B10))Conditional sum like SUMIF
=SUMPRODUCT((A2:A10="Sales")*(B2:B10>100)*1)Count with multiple criteria
Common Errors
#VALUE! - Arrays have different dimensions
Pro Tips
Multiply conditions for AND logic
Add conditions for OR logic
Use *1 or -- to convert TRUE/FALSE to 1/0
Related Functions
Need Help with SUMPRODUCT?
Describe your specific use case and our AI will generate the perfect SUMPRODUCT formula for you.
Generate SUMPRODUCT Formula