Sum numbers at different intervals
I am currently trying to measure the Elapsed Time of a database of sets of dates with different start dates and different numbers of rows. I am trying to SUM the time intervals between each row, while also having the start of the SUM reset after each data set. My current strategy doesn't seem to be working as when I try to take the SUM of the area between two ADDRESS functions, it returns the sum between the columns, instead of substituting in the ADDRESS location. If there's a way to correct the current formula in the 'Elapsed Time' column that'd be great, or if you have a different strategy all together I am open to anything!
Re: Sum numbers at different intervals
Hi, and welcome to the forum
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
One way might be to use a SUMIFS() array formula or a SUMPRODUCT() variant to sum the Interval times for each date.
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By wallygator1922 in forum Excel Formulas & Functions
Last Post: 03-06-2019, 05:29 PM
By beldin2 in forum Excel Formulas & Functions
Last Post: 04-12-2018, 07:37 AM
By BryceVBA in forum Excel Formulas & Functions
Last Post: 12-08-2017, 11:45 AM
By excel-help in forum Excel Formulas & Functions
Last Post: 07-25-2017, 08:54 AM
By CrazyChipmunk in forum Excel General
Last Post: 03-03-2017, 08:20 PM
By Domismiles in forum Hello..Introduce yourself
Last Post: 08-25-2014, 10:24 AM
By RPGreg in forum Excel Formulas & Functions
Last Post: 06-06-2013, 02:30 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1