How to multiply column and rows
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
|