1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel Need to combine SUM and VLOOKUP

Discussion in 'Business Applications' started by ch7, Nov 30, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. ch7

    ch7 Thread Starter

    Joined:
    Jun 11, 2008
    Messages:
    64
    Having real trouble combiniing SUM and VLOOKUP in excel

    I like to bring up details of how many hours orked and how much money was ernt during certain periods. selected by cells J5 and L5

    in cell L7 it will read add togther all the worked hours in columb F but only those between cells J5 and L5

    similar thing for cell L9 but to find out how much was ernt

    [​IMG]
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Hi,

    I took a look at this, and I'm not that hot with vlookups etc, but I used an extra value in column I which looks empry, I highlighted that column with the formula and the total wordked, seems okay here, see if it helps
    No macro's just change the dates and the cells where the formula = 1 will be adde, you can later just hide this column and it will work as long as you have the formula in it, you an copy it all the way down.
     

    Attached Files:

  3. ch7

    ch7 Thread Starter

    Joined:
    Jun 11, 2008
    Messages:
    64
    Well that seems to have worked very well. Thank you :)

    and seems its a 100x easier than I expected :)
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    It usually is.
    :)
     
  5. ch7

    ch7 Thread Starter

    Joined:
    Jun 11, 2008
    Messages:
    64
    Actually tested a bit further does not seem to calculate the hours. once I get to select hte first day and then the 3rd day the hours seem greatly reduced.

    Feel I know why but unsure how to fix it. the cell is formated to time as are the other cells

    and ignore me. fixed it :)
     
  6. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    could you post your sample? Check the hour format [h]:mm to add above the 24 hour value
     
  7. ch7

    ch7 Thread Starter

    Joined:
    Jun 11, 2008
    Messages:
    64
    it was indeed [h]:mm figured it out just after I posted :)

    many thanks again :)
     
  8. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Or you could use a PivotTable.
     
  9. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1029052

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice