Excel row-wise multiplication
I would like to multiply, row-by-row, two columns in an Excel sheet (in order to take the median of the resulting column).
1 3
2 5
4 2
Should become
3
10
8
How can I do that in a formula (i.e. without creating a separate column with the multiplication result)?
Solution 1:
You want an array formula...
Assuming your data starts in A1, you can type:
=MEDIAN(A1:A3*B1:B3)
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.