How to multiply column and rows

[Ganesh]

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.

 

[James Silverton]

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

 

[Gord Dibben]

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

 

[Ganesh]

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



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]

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

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

 

[James Silverton]

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

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

 

[Gord Dibben]

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

 

[Gord Dibben]

Make that CTRL + SHIFT + ENTER


Gord

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Gord Dibben]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[jasondebolt]

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/excel/HA010872921033.aspx

 

[Gord Dibben]

It was not my suggestion.

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


Gord

 

[James Silverton]

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

Gord

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

Make that CTRL + SHIFT + ENTER

Agreed! Of course.

--

James Silverton
Potomac, Maryland

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