Let's say your row is in cells B1:E1 and your column is in cells A2:A6.

Select cells B2:E2, type

=B1:E1*TRANSPOSE(A2:A5)

and hold the Control and Shift keys while you press Enter.





"Hari" wrote:

Hi,
My question is I have a row and a column of values. I am trying to multiply
the row by column and display it in a row format.
eg

Row 3 5 2 5

Column
1
4
5
6


I want the product to be displayed as
3 20 10 30
by using relative reference. It doesnt work for me. Pl. let me know if
anyone has any idea.

Thanks