Newbie question

[Emilio]

Hi all,

I need to find an easier way to do this:

= A1*B1+A2*B2+A3*B3+A4*B4+A5*B5+A6*B6 and so on

Can someone please help me.

Thanks in advance,
Emilio

 

[Katherine Coombs]

Hi Emilio,

Try this:

=SUMPRODUCT(A1:A6,B1:B6)

Expand the range (ie change A6 and B6) as necessary.

HTH,
Katherine

 

[Emilio]

Thank you very much

Emilio

-----Original Message-----
Hi Emilio,

Try this:

=SUMPRODUCT(A1:A6,B1:B6)

Expand the range (ie change A6 and B6) as necessary.

HTH,
Katherine



.