Results 1 to 33 of 33

Calculate by Match Criteria between Start/End Cells

Threaded View

  1. #31
    Forum Contributor
    Join Date
    04-09-2015
    Location
    Jamestown, TN
    MS-Off Ver
    2010
    Posts
    111

    Re: Calculate by Match Criteria between Start/End Cells

    Hi Glenn,
    I am having a major problem trying to get a couple of other formulas to work on this. If I could get you to assist me that would be great since you are familiar with the whole project so far. Sample Attached "MySample8"

    I am trying to get "G7- (Max F - Min D)" From our boots on the ground day, "2" Site Work, Row 26 this sample" all the way to "Row 49, this sample" and put that result in "L4" Scheduled Lag Days. I tried this but it really doesn't work correctly and cant figure out how to subtract the G7 before it?
    =MAX(INDIRECT("F"&11+MATCH("2",$A$12:$A$49,0)&":F"&11-1))-INDIRECT("D"&11+MATCH("2",$A$12:$A$49,0))

    Second, I am trying to Do a "Rounddown for a total of G Column * total of L Column, from our boots on the ground day, "2" Site Work to the end, row 49, this sample" and put result in "O5"

    And Finally, I am trying to "Max Days Column E - Max Days in Column L" from our boots on the ground day, "2" Site Work to the end, Row 49, this sample and the result of that would go in "O7".
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Identify the pair and calculate the time difference if certain criteria match
    By Chippi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-10-2014, 07:00 AM
  2. Replies: 9
    Last Post: 06-25-2013, 09:00 AM
  3. [SOLVED] Calculate cells based on multiple criteria
    By jealkon in forum Excel General
    Replies: 7
    Last Post: 07-11-2012, 02:26 PM
  4. Replies: 5
    Last Post: 09-22-2009, 06:11 PM
  5. [SOLVED] evaluate two cells and calculate based on criteria
    By galiant in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2006, 11:34 AM

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