From numbers in a column, sum only those that are consecutive.

		Microsoft Office Forums > Microsoft Excel > Excel
From numbers in a column, sum only those that are consecutive.

10-07-2022, 01:31 AM

Debaser

Windows 10 From numbers in a column, sum only those that are consecutive.

Office 2016

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

You could do something like the attached with a helper column and a pivot table.

Attached Files

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Return column header from first cell from consecutive cells below a threshold	zara007	Excel	6	05-30-2018 07:07 AM
Counting Consecutive Periods In Rows Using Numbers	Yaaseen23	Excel	18	03-24-2017 11:15 AM
find and replace consecutive numbers	kpl_39	Word	1	06-07-2013 05:04 AM
Spliting column with text and numbers	mjosic	Excel	3	04-04-2012 05:56 AM
Consecutive page numbers on multiple documents	georgeeasten	Word	1	02-10-2011 02:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:38 PM.