Results 1 to 44 of 44

Total until criteria is met

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-17-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    122

    Question Total until criteria is met

    Hi There

    I am looking for a formula that will use the following factors to total until criteria is met

    I have time intervals in A2:A61
    Corresponding results in column B2:B61

    My criteria total is in O3 (I also have a second criteria in F2)

    In column O6 downwards I want each result from A1:A60 to fill in until the total in O66 gets within the creteria in O3,I would also only like the results to show after time interval criteria in F2 (so for example if F2 has 20 seconds i want it to look at the table in A2:A61 and return any result form B2:B61 that are 20 and above to total until criteria in O3 is met/nearly met), it will more than likely never get the right number but if possible I don’t want it to exceed the criteria.

    I have tried vlookups, subtotals, ifs formula as well as looking online for a similar question but to no avail.

    I have included an example of my sheet if it helps.

    Any help would be appreciated.Attachment 411627
    Attached Files Attached Files
    Last edited by dave1983; 08-04-2015 at 06:14 AM. Reason: forgot to add extra info

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2013, 07:41 PM
  2. Need one column total if criteria meets another columns criteria
    By jebrown in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2013, 08:47 PM
  3. [SOLVED] Sum based on criteria and show total only on row that has criteria
    By NU2vba in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2012, 03:59 PM
  4. sum total of specific criteria
    By masond3 in forum Excel General
    Replies: 2
    Last Post: 11-12-2011, 05:30 AM
  5. Sum total from different sheets, given certain criteria
    By Climaxgp in forum Excel General
    Replies: 2
    Last Post: 09-14-2009, 06:16 AM
  6. Get a sum total based on three criteria
    By Weasel in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-12-2009, 02:33 PM
  7. how to total based upon criteria
    By mkmed in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-22-2008, 07:38 AM
  8. Getting total per criteria
    By oakman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2007, 02:01 PM

Tags for this Thread

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