+ Reply to Thread
Results 1 to 2 of 2

Sum numbers at different intervals

  1. #1
    Registered User
    Join Date
    03-13-2020
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    1

    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!

    Thanks.

    Excel Snapshot.PNG

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating a Table for showing Intervals between random numbers
    By wallygator1922 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2019, 05:29 PM
  2. counting numbers in different time intervals
    By beldin2 in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 04-12-2018, 07:37 AM
  3. [SOLVED] Converting mixed numbers into time intervals
    By BryceVBA in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-08-2017, 11:45 AM
  4. Summing Monthly Numbers with Increases after Specified Intervals
    By excel-help in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2017, 08:54 AM
  5. [SOLVED] Incrementing column letters and row numbers at different intervals
    By CrazyChipmunk in forum Excel General
    Replies: 6
    Last Post: 03-03-2017, 08:20 PM
  6. Finding average in intervals for a series of numbers in an excel column.
    By Domismiles in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-25-2014, 10:24 AM
  7. Averaging numbers at intervals
    By RPGreg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-06-2013, 02:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1