What is the BEST way to add values residing in two non-consecutiv.

L

lozseb

What is the BEST way to perform the following:

(A * AA) + (B *AB)+(C * AC)+(D * AD)+......

Where:

A = Position of column
AA = Position of Column
 
B

Bob Phillips

or do you mean the column number

=SUMPRODUCT(COLUMN(A1:E1),COLUMN(AA1:AE1))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
L

lozseb

THANK YOU SO VERY MUCH!!!!...

IF IT WASN'T FOR YOUR ADVICE I WOULD HAVE HAD TO WRITE A 10 (TEN) LINE
FORMULA TO ADD 66 COULUMNS....

THANK YOU AGAIN!!!!
 
Top