Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-06-2022, 08:27 AM
gdougher gdougher is offline From numbers in a column, sum only those that are consecutive. Windows 11 From numbers in a column, sum only those that are consecutive. Office 2016
Novice
From numbers in a column, sum only those that are consecutive.
 
Join Date: Oct 2022
Posts: 1
gdougher is on a distinguished road
Default From numbers in a column, sum only those that are consecutive.

I have a s/s for billing that I use when submitting claims in an application that only allows input for a single date, or, if dates are consecutive, I must sum the amounts in order to enter the line item.

For example: John Doe for the month of September
9/1/2022 $13.96 Amt Claim Line 1 = $13.96
9/8/2022 $13.96 Amt Claim Line 2 = $13.96
9/12/2022 $13.96) Amt Claim Line 3 = $27.92


9/13/2022 $13.96)
9/15/2022 $13.96 Amt Claim Line 4 = $13.96
9/26/2022 $13.96 Amt Claim Line 5 = $13.96
9/29/2022 $13.96 Amt Claim Line 6 = $13.96

Is there a formula I can use that will do this for me through the 500+ rows in my s/s?
Reply With Quote
  #2  
Old 10-07-2022, 01:31 AM
Debaser's Avatar
Debaser Debaser is offline From numbers in a column, sum only those that are consecutive. 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
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, 8 views)
Reply With Quote
  #3  
Old 10-07-2022, 01:44 PM
Steve Kunkel Steve Kunkel is offline From numbers in a column, sum only those that are consecutive. Windows 10 From numbers in a column, sum only those that are consecutive. Office 2019
Advanced Beginner
 
Join Date: May 2019
Location: Seattle area
Posts: 77
Steve Kunkel is on a distinguished road
Default

What if the date goes from a Friday to a Monday... Is that consecutive?
Reply With Quote
  #4  
Old 10-07-2022, 01:48 PM
Steve Kunkel Steve Kunkel is offline From numbers in a column, sum only those that are consecutive. Windows 10 From numbers in a column, sum only those that are consecutive. Office 2019
Advanced Beginner
 
Join Date: May 2019
Location: Seattle area
Posts: 77
Steve Kunkel is on a distinguished road
Default

Paste a chunk of the raw data into a sheet and post it, if you can.

Does the data always come to you in raw text format? Is it separated with {tab}s?
Reply With Quote
Reply

Thread Tools
Display Modes


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
From numbers in a column, sum only those that are consecutive. 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 06:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft