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.

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

"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

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

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


First try using a signature after your response, it makes it less work
for me. You might also want to read up on Array Formulas; they are
useful.

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

Taking my example, Select C1:C8, in the formula bar put =, then select
A1:A8, insert *, select B1:B8; give Ctr--enter.

--

James Silverton
Potomac, Maryland

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

Make that CTRL + SHIFT + ENTER


Gord

On Sat, 23 Aug 2008 11:36:00 -0700, Ganesh
wrote:

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

Hi Gord,

Make that CTRL + SHIFT + ENTER


Surely that won't do anything unless you also SUM() it:

=SUM(A1:A8*B1:B8)

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Make that CTRL + SHIFT + ENTER


Gord

On Sat, 23 Aug 2008 11:36:00 -0700, Ganesh
wrote:

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

Sandy

Not sure what OP wants.

Multiply A1*B1 then A2*B2 or multiply the sum of A1:A8 by sum of B1:B8.

I assumed the former.

=A1:A8*B1:B8 array entered in C1:C8 does that


Gord

On Sat, 23 Aug 2008 20:38:08 +0100, "Sandy Mann"
wrote:

Hi Gord,

Make that CTRL + SHIFT + ENTER


Surely that won't do anything unless you also SUM() it:

=SUM(A1:A8*B1:B8)

Gord wrote on Sat, 23 Aug 2008 12:02:27 -0700:

Gord

On Sat, 23 Aug 2008 11:36:00 -0700, Ganesh
wrote:

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


Make that CTRL + SHIFT + ENTER

Agreed! Of course.

--

James Silverton
Potomac, Maryland

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

In C1 enter =A1*B1

Double-click the fill handle of C1 to copy the formula down column C

BTW...........a "desire box" is called a "cell"


Gord Dibben MS Excel MVP


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

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.

"Gord Dibben" wrote:

In C1 enter =A1*B1

Double-click the fill handle of C1 to copy the formula down column C

BTW...........a "desire box" is called a "cell"


Gord Dibben MS Excel MVP


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

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.


Still i m not able to do this i double click on C1 then what i have to do,
to multiply all tha A and B row

Assuming you have numbers in column A and column B, the double-click on the
fill handle of C1 will auto-copy the formula down as far as you have data in
column B.

The formula will increment to =a2*b2 and =a3*b3 etc.

The fill handle is the small black square at lower right corner of the cell.


Gord

On Sat, 23 Aug 2008 11:46:01 -0700, Ganesh
wrote:



"Gord Dibben" wrote:

In C1 enter =A1*B1

Double-click the fill handle of C1 to copy the formula down column C

BTW...........a "desire box" is called a "cell"


Gord Dibben MS Excel MVP


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

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.


Still i m not able to do this i double click on C1 then what i have to do,
to multiply all tha A and B row

Hi Ganesh,

The easiest way to do this is use the fill handle or auto copy per
Gord's comments. Another way is to use an array formula (sometimes
called CSE formulas or Control Shift Enter formulas).

Array formula example:
I'm assuming that you have data in cells A1:A8 and B1:B8...

1) select C1:C8
2) with cells C1:C8 selected, type the following: "=A1:A8*B1:B8"
3) press "Ctrl + Shift + Enter" keys all at the same time. By pressing
"Ctrl + Shift + Enter", you are essentially placing the same formula
in multiple cells.

That's it. Cells A1:A8, B1:B8, and C1:C8 should now look someting like
this:

1 2 2
2 3 6
3 4 12
4 5 20
5 6 30
6 7 42
7 8 56
8 9 72

For more info on array formulas, check out the following links:
http://www.mrexcel.com/tip011.shtml
http://www.cpearson.com/excel/ArrayFormulas.aspx
http://office.microsoft.com/en-us/ex...872921033.aspx


On Aug 23, 11:12*am, Ganesh wrote:
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.