How to multiply column and rows
 

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.

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

How to multiply column and rows
 

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.

How to multiply column and rows
 

"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

How to multiply column and rows
 

"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

How to multiply column and rows
 

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

How to multiply column and rows
 

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

How to multiply column and rows
 

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.

How to multiply column and rows
 

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.

How to multiply column and rows
 

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)

How to multiply column and rows
 

Ah yes! I see what you mean. I always avoid entering arrays like that
because you then can't change one element of them which I find very
annoying.

Sorry for the confusion.

--
HTH

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
...
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)

How to multiply column and rows
 

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.

How to multiply column and rows
 

It was not my suggestion.

I was correcting another's post who stated CTRL + ENTER for an array
formula.


Gord

On Sat, 23 Aug 2008 21:44:26 +0100, "Sandy Mann"
wrote:

Ah yes! I see what you mean. I always avoid entering arrays like that
because you then can't change one element of them which I find very
annoying.

Sorry for the confusion.

How to multiply column and rows
 

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