Hi

How many routes would there be from town1 to town2? If there is only one, and your data table was 3 columns (start town, end town, distance), then you could use SUMPRODUCT to get the distance.

If there are multiple routes and all are entered, then what result do you want? The min distance, or the total of all distances???

Perhaps to help clarify, an example spreadsheet with representative data and expected result would help.


rylo