SUMPRODUCT Formula Generator
Describe the weighted total, OR condition, or row-by-row logic you need in plain English and get a ready-to-use SUMPRODUCT formula for Excel or Google Sheets.
5 free tries without an account
SUMPRODUCT syntax
=SUMPRODUCT(array1, [array2], [array3], ...)With one array, SUMPRODUCT just sums it. With two or more same-sized arrays, it multiplies them together position by position, then sums the results — which is also how it's used to build OR-condition counts and sums that SUMIFS/COUNTIFS can't handle. Formulon works out the right array logic for whatever calculation you describe.
Examples
Calculate a weighted total (quantity × price)
=SUMPRODUCT(B2:B10,C2:C10)Multiplies each row's value in B by the corresponding value in C, then sums every result — e.g. quantity × unit price across many rows to get a total order value in one formula.
Count rows matching either of two conditions
=SUMPRODUCT((B2:B10="West")+(B2:B10="East"))Each comparison produces an array of TRUE/FALSE values (1s and 0s); adding the two arrays together and summing counts every row where the region is "West" or "East" — something SUMIFS/COUNTIFS can't express directly since they only combine conditions with AND.
Frequently asked questions
What can SUMPRODUCT do that SUMIFS can't?
SUMIFS only handles AND-style conditions (every criteria must be true). SUMPRODUCT can express OR conditions, weighted sums (multiplying two columns together before adding), and other row-by-row logic that doesn't fit SUMIFS's fixed pattern.
How do I calculate a weighted total, like quantity times price?
Feed two equal-sized ranges directly into SUMPRODUCT: =SUMPRODUCT(B2:B10,C2:C10) multiplies each row's quantity by its price, then adds up all the results — no helper column needed.
How do I count or sum with an OR condition across columns?
Add the conditions together instead of multiplying: =SUMPRODUCT((B2:B10="West")+(B2:B10="East")) counts rows where the region is West OR East, since TRUE/FALSE become 1/0 and get added.
Is SUMPRODUCT the same in Google Sheets?
Yes, SUMPRODUCT has identical syntax and behavior in both Excel and Google Sheets.
Don't want to write it by hand?
Describe what you need in plain English and get a ready-to-use formula in seconds.
Try the formula generator