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