Thread: From numbers in a column, sum only those that are consecutive.
View Single Post
 
Old 10-07-2022, 01:31 AM
Debaser's Avatar
Debaser Debaser is offline Windows 10 Office 2016
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
You could do something like the attached with a helper column and a pivot table.
Attached Files
File Type: xlsx Sequential dates.xlsx (12.9 KB, 10 views)
Reply With Quote