ID the 3 starting points ID the 2 destination points Target Cell: use the sum of

Question

ID the 3 starting points
ID the 2 destination points
Target Cell: use the sum of all starting points in the target cell ****OR*** the negative of the sum [= - ( LA + Se)] of all destination points.

From To Capacity Stuttgart Rotterdam 50 Stuttgart Bordeaux 70 Stuttgart Leipzig 70 Erfurt Rotterdam 30 Erfurt Hamburg 210 Erfurt Miami 70 Rotterdam New York 80 Bordeaux New York 40 Bordeaux New Orleans 50 Mumbai New York 44 Leipzig New Orleans 30 Hamburg New York 30 Hamburg Boston 40 Hamburg New Orleans 70 Hamburg Seattle 50 Miami Seattle 70 Leipzig Chicago 30 Chicago Seattle 30 New Orleans Los Angeles 70 New York Los Angeles 110 New York Seattle 88 Boston Los Angeles 10 Boston Seattle 20

Explanation / Answer

Block of Cells
Use a range to access a single cell or block of cells (may span many rows and columns) as in:
range aa = 1[2]; // cell(2,1), row2 of col(1)
range bb = 1[1]:3[10]; // cell(1,1) to cell(10,3)
Note: a range variable representing a block of cells can be used as an X-Function argument only, direct
calculations are not supported.
Matrix Data
For matrix data, the RangeString is
[MatrixBookName]MatrixSheetNameOrIndex!MatrixObject
Make an assignment such as:

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---