Posted to microsoft.public.excel.misc

James Silverton[_3_] James Silverton[_3_] is offline

external usenet poster

Posts: 119

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
total of multiple rows + multiply	israel	New Users to Excel	3	August 14th 08 09:52 PM
How to multiply rows to match the specific value in the row	Paatu	Excel Discussion (Misc queries)	3	October 5th 07 06:58 AM
MULTIPLY CELLS IN ROWS CONTINUALLY	ALY33	New Users to Excel	1	May 3rd 07 05:06 PM
Divide Column A by Column B multiply Column C	Stumped	Excel Worksheet Functions	3	December 28th 05 05:51 AM
How do I multiply a whole column by a number?	cowboyeti	Excel Worksheet Functions	1	July 13th 05 05:17 PM

All times are GMT +1. The time now is 12:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us