Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Save External Link Values | Excel Discussion (Misc queries) |