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
3 10 8
How can I do that in a formula (i.e. without creating a separate column with the multiplication result)?