=SUMPRODUCT(array; [array1]; ...)

Zoho’s official reference uses the expression above. Brackets indicate optional arguments, not text to type. All formula examples use Zoho’s English help syntax with semicolon argument separators. Numeric displays may gain currency symbols or decimal places depending on cell formatting. Read the answer as a number unless the guide expressly says it is text. The formulas below use cell references relative to the stated table.

Separate four-row practice dataset for this function: In a fresh sheet, enter exactly this table starting at A1. It deliberately uses product unit prices and quantities rather than the general order-status ledger.

Enter the result formulas in an empty cell such as E2, not inside B2:C5.

Main calculation

=SUMPRODUCT(B2:B5;C2:C5)

Expected result: 96. Four line totals are (2.50×12)=30, (4.00×7)=28, (1.20×20)=24, and (3.50×4)=14. Their sum is 96.

Check the cell range character by character. If your result is different, confirm the row numbers, number formatting and that your inputs match the sample before changing the formula. The numbers here are calculated independently from the table, not copied from an application screenshot.

Second practical example

=SUMPRODUCT(C2:C5;B2:B5)

Expected result: 96. Reversing the two numeric arrays produces the same line-by-line multiplications and therefore the same total 96; this confirms that the arrays are aligned.

This is a second, separately reasoned test case using the same named inputs. When working with another workbook, change the column references deliberately and keep comparison criteria or array dimensions aligned.

=ROUND(SUMPRODUCT(B2:B5;C2:C5)/SUM(C2:C5);2)

Expected result: 2.23. The four quantities total 43 units. A weighted-average unit price is 96/43 = 2.232558…, rounded to 2.23. This weights each price by its quantity, unlike AVERAGE(B2:B5), which weights each product line equally.

For formula composition, first confirm the simpler formula works, and only then add nested functions or criteria. The advanced formula must be entered in a different unused cell, e.g. H4, to keep it away from the source ranges.

Each array must cover the same dimensions, as Zoho’s official reference explicitly notes; B2:B5 paired with C2:C6 is not a valid alignment. If prices or quantities were imported as text, inspect their data types before trusting the total. Empty or nonnumeric inputs and errors can behave differently between products; test those cases in the actual Zoho app before writing a production financial model. This example assumes unit prices already have the desired currency and tax basis.

Typical formula failures to investigate: #NAME! can indicate a misspelled function or undefined name; #REF! suggests a broken range reference; #VALUE! can indicate a wrong argument type. These are documented as possible errors in Zoho’s function help, but the precise error for a specific imported cell was not native-tested here. Check the formula bar, source cell data types, and range sizes before deciding that the function is broken.

If a formula returns an unexpected blank or zero, compare the relevant input rows with the worked sample. Check mixed numeric/text imports, copy-pasted quotes, leading/trailing spaces, and whether the selected input cells were moved or renamed. Do not infer an application version limitation solely from one failed formula: confirm function availability and syntax in Zoho’s in-app formula assistant.

Excel and Google Sheets also offer SUMPRODUCT, but boolean coercion and array-expression shortcuts are less portable than a simple SUMPRODUCT(prices; quantities) pair. Use the two aligned numeric ranges first.

Cross-software transfer: Excel, Google Sheets, and LibreOffice Calc also use the named function for ordinary numerical cases, but do not copy argument separators blindly: Zoho’s English help examples use semicolons (;). Syntax details, empty-cell behavior, handling of text and errors, and compatibility with exports can differ. Test a small verified dataset after migrating rather than assuming a Zoho formula will behave exactly like an Excel or Numbers one.

• SUM guide
• ROUND guide
• AVERAGE guide
• SUBTOTAL guide

• Zoho Sheet — function documentation
• Zoho Sheet — official function category
• Zoho Sheet — full function index

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.