SUMPRODUCT Formula Generator
SUMPRODUCT multiplies corresponding elements in arrays and returns the sum. It's extremely versatile — used for weighted averages, conditional calculations, and multi-criteria analysis without needing array formulas.
Syntax
=SUMPRODUCT(array1, [array2], ...)Try it — generate a SUMPRODUCT formula
Examples
Weighted average grade
=SUMPRODUCT(B2:B10, C2:C10) / SUM(C2:C10)Multiplies each grade by its weight, sums the products, divides by total weight.
Conditional sum (like SUMIFS)
=SUMPRODUCT((A2:A100="East")*(C2:C100>500)*(D2:D100))Sums column D where column A is "East" and column C is over 500.
Tips
- ✓SUMPRODUCT can replicate SUMIFS functionality and is compatible with older Excel versions.
- ✓Use TRUE/FALSE conditions multiplied together for AND logic.
- ✓For OR logic, add conditions with + instead of multiplying with *.
Related Formulas
SUMIFS
SUMIFS adds up values that meet multiple criteria. It's essential for financial ...
AVERAGEIFS
AVERAGEIFS calculates the average of cells that meet multiple criteria. Useful f...
COUNTIFS
COUNTIFS counts cells that meet multiple criteria across different columns. Perf...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free