FG
💻 Software

Excel row-wise multiplication

Fresh5 days ago
Mar 15, 202616140 views
Confidence Score0%
0%

Problem

I would like to multiply, row-by-row, two columns in an Excel sheet (in order to take the median of the resulting column). Should become How can I do that in a formula (i.e. without creating a separate column with the multiplication result)?

Error Output

1  3
2  5
4  2

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel row-wise multiplication

Low Risk

You want an array formula... Assuming your data starts in A1, you can type: and the press Ctrl + Shift + Enter to enter it into the cell as an array formula. If you do it correctly, you'll see the formula enclosed in curly braces by Excel.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment