+ Reply to Thread
Results 1 to 7 of 7

adding values after looking & matching day & time condition from another sheet

  1. #1
    Registered User
    Join Date
    02-27-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    53

    adding values after looking & matching day & time condition from another sheet

    kindly see the attached file, i had tried to evaluate data using sum product, index & match function but not successful. it is the same sheet on which Jacc & others had helped me out but now again struck in middle.

    i have shown desired result & seeking a formula to calculate after looking & match values from another data sheet.
    Attached Files Attached Files
    Last edited by tabkaz; 03-20-2015 at 05:10 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    7,821

    Re: sumation of data after matching day & time from data sheet

    in D11 (and copy right) array formula* shall be enough:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    provided that headers in row 10 are right (for instance you can use in D10 and copy right):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    array formula - confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
    Best Regards,

    Kaper

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    7,821

    Re: sumation of data after matching day & time from data sheet

    And a bit more complicated formula for D14 (again: array formula)

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The issue here was that source data has to be shifted to pick up only three hours which are of interest.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-27-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: sumation of data after matching day & time from data sheet

    Dear kaper thanks for replying to the post, i saw that formula u posted for problem 1 was good enough to find a solution,
    but for problem 2 i still could found a solution.
    i have reedited the attachment to incorporate the changes made in sheet. kindly see if i can have a solution to it.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-27-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: sumation of data after matching day & time from data sheet

    kindly look at this thread & helps me out to solve it please...

  6. #6
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,572

    Re: adding values after looking & matching day & time condition from another sheet

    Did this continue in a new thread or is it still open?
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  7. #7
    Registered User
    Join Date
    02-27-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: adding values after looking & matching day & time condition from another sheet

    Hi Jacc

    i did found a solution after days of searching & looking.

    Can u look to the below link i am seeking solution to a new problem

    http://www.excelforum.com/excel-form...time-band.html

+ 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. Matching Data from one sheet to data on another and returning a value
    By willmatic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2014, 12:12 AM
  2. matching data rows from one sheet to another for a data return
    By moonchild2008 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-18-2013, 03:15 PM
  3. Matching data from one sheet to another, using a column of common data
    By jacktastic in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-18-2013, 12:43 PM
  4. Replies: 1
    Last Post: 06-26-2012, 09:43 PM
  5. Replies: 17
    Last Post: 05-19-2009, 11:34 AM

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