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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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!!!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

complex sort search and replace macro 2
COUNTIF AND 4
Search two columns in list for first and last name and return Id 4
Arrays 2
OR in SUMPRODUCT formula 3
Hiding columns in Excel 2003 2
Creating a function 3
pick from list 1

Back
Top