View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James Silverton[_3_] James Silverton[_3_] is offline
external usenet poster
 
Posts: 119
Default 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