a long representative list of the distances would help

--
Don Guillett
SalesAid Software

"Max" wrote in message
...
Hello,
I need help please, with a formula which calculates the cumulative sum of
a
column of distances in kilometers.
When the cumulative total reaches a celing of 350kms, it must restart the
cumlulative total again.
If any distance is greater than 350kms then it must give the cumulative
total excluding the greater value, and highlight the cell, show the
greater
value in a seperate column and restart the cumulative count again.

My opbjective is to plan a travel route over 5000kms and a scheduled stop
every 350kms for the night. This is to plan where I will be stopping over
to
make the booking in advance.

Thank you for your help.

Max