Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help! cumulative returns | Excel Worksheet Functions | |||
How do I do a cumulative frequency graph? | Charts and Charting in Excel | |||
Line graph for cumulative number over time | Charts and Charting in Excel | |||
Formula Help for Cumulative Result | Excel Discussion (Misc queries) | |||
Cumulative Summing | Excel Discussion (Misc queries) |