# Solved: Excel Need to combine SUM and VLOOKUP

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

Not open for further replies.
1. ### ch7Thread 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

2. ### KeebellahTrusted 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.

File size:
11.9 KB
Views:
54
3. ### ch7Thread 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. ### KeebellahTrusted Advisor

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

5. ### ch7Thread 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. ### KeebellahTrusted 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. ### ch7Thread 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

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

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.

over 733,556 other people just like you!