"James Silverton" wrote:

Ganesh wrote on Sat, 23 Aug 2008 11:12:00 -0700:

Hello friends i know how to multiply a single row or column
that if i want that Multiply A1 and A2 then i write in my
desire box "=A1*A2" thats it.

But the problem is this that i want to multiply all data of
the A row with B row and want to show in C how i can.

It could be done with an array formula: Select say, C1:C8,
=A1:A8*B1:B8, Ctrl Enter.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not



I dont know where i type the array formula, can u please tell me the full
procedure