Newbie question

  • Thread starter Thread starter Emilio
  • Start date Start date
E

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
 
Hi Emilio,

Try this:

=SUMPRODUCT(A1:A6,B1:B6)

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

HTH,
Katherine
 
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



.
Click to expand...
 
Back
Top