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)