Multiple VLOOKUP

[elad]

HI.

I have a sheet that shall sum all registrated hours pr customer pr month. There is one sheet pr customer. In the sum sheet, I want to match date with date i "customersheet" and based on that sum all hours registrated that month.

I use Vlookup to find the date (ie. 1.feb) and that works fine. The problem is when there are registrated many tasks on the same date. If there i.e is registrated 2 tasks on the same date, I cant get the Vlookup to sum it!

Thanks for any help!

elad
Norway

[EdMac]

Have you tried SUMPRODUCT?

http://xldynamic.com/source/xld.SUMPRODUCT.html

Ed

[elad]

I have tried Sumproduct, but not so familiary with that formula.
In sum sheet I have these columns:

A B
01.jan The formula I want to create
02.jan
03.jan
etc
etc
etc

Based on A1 find the matching date/hours in Sheet Customer X.

The Customer X sheet looks like this.

A (date) B(description of task) C (Hours)
01.jan Working with.... 4
02.jan Working with.... 3
02.jan Working with.... 4
10.jan Working with.... 5

So in my example I want the formula to calculate 7 hours for this customer on the 02. jan. With the Vlookup formula it only counts 3 (the first)

Maybe Sumproduct works, but have not used that formula that much, but I can try.

Thanks!

elad

[EdMac]

Something like the attached maybe. Sumif will work for one criteria, sumproduct for more than 1.

Ed

[elad]

I think the SUM IF will help me.

Tanks a lot!

elad

[EdMac]

Ok,

Feel free to post back if you need to.

Ed