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.