I am trying to think of a formula that will give me the result that I would
like:
Example
Sheet 1
B1=sheet 2 B1 thru B25=sheet 2 B25
C1 equals Sheet 2 Cell B1 as the starting distance
D1 equals the distance from the last item to the starting point
E1 equals the overall distance
Sheet 2
A1-A25 raw data
B1-B25 converts raw data to feet

My problem is, how can I get it C1 to see whatever the last number in Sheet
2 column B as the distance from the last item back to the source? I was
wondering because its not always going to be 25 items.