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

What is the BEST way to perform the following:

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

Whe

A = Position of column
AA = Position of Column

If I understand you correctly:

=SUMPRODUCT(A1:E1,AA1:AE1)

In article ,
lozseb wrote:

What is the BEST way to perform the following:

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

Whe

A = Position of column
AA = Position of Column

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)


"JE McGimpsey" wrote in message
...
If I understand you correctly:

=SUMPRODUCT(A1:E1,AA1:AE1)

In article ,
lozseb wrote:

What is the BEST way to perform the following:

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

Whe

A = Position of column
AA = Position of Column

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!!!!

"JE McGimpsey" wrote:

If I understand you correctly:

=SUMPRODUCT(A1:E1,AA1:AE1)

In article ,
lozseb wrote:

What is the BEST way to perform the following:

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

Whe

A = Position of column
AA = Position of Column