How to Multiply a List of Numbers in Excel: 10 Methods

If your numbers are in A2:A6, enter =PRODUCT(A2:A6) to multiply them all together in Excel. The methods below cover that total, running and row-by-row products, multiplying a range by a factor, and working with selected values, so you can choose a method that matches your task in Microsoft Excel for Microsoft 365 on Windows.

1. Multiply the Entire List with PRODUCT

PRODUCT is the straightforward choice when you want one result from every number in a range. With the list 2, 3, 4, 5, and 6 in A2:A6, enter =PRODUCT(A2:A6) in another cell; the result is 720, because 2 × 3 × 4 × 5 × 6 equals 720. The reference expands automatically if you edit a value already inside the range, though it will not include new entries typed below A6 unless you update the reference.

This method is easier to read and maintain than typing a long chain of multiplication operators, especially when the list has dozens or hundreds of entries. PRODUCT ignores blank cells and text in a referenced range, but a zero in the range makes the total zero, as multiplication requires; an error value in the range will generally make the formula return an error too. Check that the selected cells contain the intended numeric values before relying on the result.

2. Use PRODUCT with Separate Ranges or Cells

You do not have to multiply one uninterrupted block: PRODUCT can take several cell or range references as arguments. With 2 and 3 in A2:A3 and 4 and 5 in C2:C3, enter =PRODUCT(A2:A3,C2:C3) to get 120, without including anything in column B. This is useful when the values you need are separated by labels, notes, or other data that should not be part of the calculation.

You can also include a single cell alongside ranges, which is handy when one number is stored in a separate assumption cell. For example, a fixed multiplier can sit in E1 while the list is in A2:A5, and the PRODUCT formula can reference both; the result changes when either the list or E1 changes. Be deliberate about which cells you select, because a reference to the wrong range can produce a plausible-looking but incorrect result.

3. Type a Short Multiplication Formula with Asterisks

For a handful of values, the multiplication operator is often the clearest option. With 2 in A2, 3 in B2, and 4 in C2, enter =A2*B2*C2 in D2; Excel returns 24. The asterisk means multiply, and Excel evaluates the expression using the referenced cell values rather than the text of the cell addresses.

This approach is useful when the calculation has only a few inputs and you want to see exactly which ones contribute to the answer. It is less convenient than PRODUCT for a long list: adding another value requires editing the formula, and it is easier to omit a cell or create a typo in a lengthy chain. Use cell references rather than typing the numbers directly when you expect the inputs to change.

4. Calculate a Running Product with SCAN

A running product shows the cumulative multiplication after each item, rather than only the final total. With 2, 3, 4, and 5 in A2:A5, enter =SCAN(1,A2:A5,LAMBDA(acc,value,acc*value)) in B2; in Microsoft 365, Excel spills 2, 6, 24, and 120 into B2:B5. The first argument sets the starting value to 1, while the LAMBDA updates the accumulated result by multiplying it by the next value.

This is valuable for tracking sequential growth, chained factors, or the cumulative effect of a series of rates. It also avoids copying a separate formula down the column, and the spilled results update when the source list changes. SCAN and LAMBDA are available in Microsoft 365 and Excel 2024; older perpetual versions may not support them, so use a copied-down formula if Excel displays a function-name error.

5. Multiply Corresponding Values Row by Row

When each row contains a pair of values to multiply, make a result column rather than combining the whole list into one total. With quantities in A2:A5 and prices in B2:B5, enter =A2*B2 in C2, then use the fill handle to copy the formula through C5. If the first row is 3 and 4, C2 returns 12; a later row containing 5 and 6 returns 30.

Excel adjusts the relative references as you copy down, so the formula in C3 becomes A3 times B3. This is the practical choice for line totals, paired measurements, or any dataset where each row is its own calculation. If one input should remain fixed while you fill, use an absolute reference for that cell, such as $E$1, so Excel does not shift it to E2, E3, and so on.

6. Multiply Two Lists Element by Element with a Spilled Formula

For two same-length lists, Microsoft 365 can multiply corresponding positions with one dynamic-array formula. With values in A2:A4 and B2:B4, enter =A2:A4*B2:B4 in C2; if A contains 2, 3, 4 and B contains 5, 7, 8, Excel spills 10, 21, and 32 into C2:C4. Each result is a pairwise product, not the product of every number in both lists.

This is convenient when the source lists may change length and you want to avoid filling a formula down manually. The cells below the formula must be empty, or Excel will show a #SPILL! error because it cannot place the results in the occupied cells. Dynamic array formulas work in Microsoft 365 and Excel 2021 or later; in older Excel versions, enter a row formula such as =A2*B2 and copy it down instead.

7. Multiply a Range in Place with Paste Special

Paste Special can permanently multiply existing values by one constant, which is useful when you need to convert a whole list and do not want an extra formula column. Type the factor, such as 1.1, in an unused cell and copy it; select the destination numbers, then choose Home > Paste > Paste Special > Multiply and confirm with OK. For instance, applying 1.1 to 100, 200, and 300 changes those cells to 110, 220, and 330.

Because this operation replaces the selected values, keep a copy of the original data or use a spare worksheet if you may need to reverse the conversion later. Paste Special is a good fit for a one-time adjustment, such as changing units or applying a fixed scale to a prepared range. It is not a live calculation: changing the factor cell afterward will not update values that were already multiplied.

8. Keep the Original List and Scale It in a Helper Column

A helper column is safer than changing source values when you want every number multiplied by the same factor while keeping the original list intact. With source values in A2:A5 and the factor 1.1 in E1, enter =A2*$E$1 in B2 and fill down to B5; if A2 is 100, B2 returns 110. The dollar signs lock E1 as the formula is copied, while A2 adjusts to A3, A4, and A5.

This arrangement makes the calculation transparent: readers can compare each source value with its scaled result, and changing E1 recalculates the entire output column. It is useful for applying a consistent conversion factor or scenario assumption without overwriting inputs. Label E1 clearly with what the factor represents, and format the result cells appropriately if the values represent currency, percentages, or measured quantities.

9. Multiply Only Values That Meet a Condition

If only some entries belong in the product, combine PRODUCT with FILTER in Microsoft 365 or Excel 2021 and later. With values in A2:A6, matching labels in B2:B6, and the word Include in D2, enter =PRODUCT(FILTER(A2:A6,B2:B6=D2)) in E2; if the included values are 2 and 4, the result is 8. FILTER first returns values whose labels match D2, and PRODUCT multiplies that filtered set.

This is more flexible than manually selecting a scattered set of cells because changing a label or the criterion updates the result. It is useful for category-specific totals, though remember that the product is not an additive total and can become zero if any selected value is zero. If no rows match, FILTER returns an error unless you provide its optional empty-result argument; consider what the workbook should display in that case before sharing it.

10. Multiply a Column in Power Query

Power Query is an option when you import or repeatedly refresh a table and want the multiplication to be part of the data-preparation steps. In Excel for Microsoft 365 on Windows, select a cell in the table and choose Data > From Table/Range; in the Power Query Editor, select the numeric column and choose Transform > Standard > Multiply, then enter the factor. For example, multiplying a column containing 10, 20, and 30 by 3 produces 30, 60, and 90 when the query is loaded back to a worksheet.

This approach is worth considering when the source is refreshed regularly, because Power Query can repeat the transformation during refresh rather than requiring you to reapply a worksheet operation. It changes the values in the query output, not the original external source, and it does not create a live worksheet formula for each row. On Mac, Power Query availability and options depend on the Excel build; if the described editor command is not available, use a worksheet helper column or Paste Special instead.

How to Choose

Start by deciding what “multiply a list” means for your task. If you need one number representing the product of every entry, choose PRODUCT; if you need separate outcomes for each row, use a copied formula or a spilled element-by-element formula. For cumulative results in order, use SCAN where supported, because a single final product does not show the intermediate stages.

Next, consider whether the source data should remain unchanged. Paste Special is fast for a one-time in-place conversion, but a helper column keeps the source values and lets a factor update the results. Use PRODUCT with FILTER when the selection depends on a category or flag, and use Power Query when the calculation belongs in a repeatable import-and-refresh process.

Compatibility and auditability matter too. PRODUCT and ordinary asterisk formulas work in older Excel editions, while the dynamic-array examples need newer versions; use a row formula if colleagues may open the workbook in older software. For any method, verify the range boundaries, confirm whether blanks or zeros are meaningful, and test the result with a small example whose arithmetic you can check independently.

Frequently Asked Questions

Does PRODUCT multiply every number in the selected cells?
It multiplies the numeric values in the referenced range, while ignoring blank cells and text entries. A zero is included and makes the result zero, so inspect the range if the answer seems unexpectedly low.

Why does my PRODUCT formula return zero?
At least one referenced value may be zero, including a zero produced by another formula. Check the source cells and any formulas feeding them; a blank or text value alone is not the same as zero.

Can I multiply a range by a number without changing the original values?
Yes. Put the factor in a cell and use a helper-column formula such as =A2*$E$1, with the original value in A2 and the factor in E1, then fill it down. The source list remains unchanged.

How do I multiply every value by the same percentage increase?
Use a factor equal to 1 plus the increase: for a 10% increase, the factor is 1.1. With the original value in A2, =A2*1.1 returns 110 when A2 is 100; multiplying by 10% alone would return only the increase amount, not the adjusted value.

Why does Excel show #SPILL! for a list multiplication formula?
A dynamic-array formula needs clear cells where its results will appear. Remove or move anything blocking the spill range, and check that the result area does not contain merged cells.

Can I multiply numbers across different worksheets?
Yes. PRODUCT accepts worksheet references, and formulas can use references such as Sheet2!A2 when the sheet name has no spaces. If a sheet name contains spaces, surround it with single quotes, for example ‘Monthly Data’!A2.

Final Thoughts

For one combined product, begin with PRODUCT; for row results, use multiplication formulas; and for a fixed adjustment, decide whether you need a reversible helper column or a permanent Paste Special change. Matching the method to the outcome—and checking the range, zeros, and Excel version—helps keep the calculation both accurate and easy to maintain.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.