If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum with IF and IF/Where
Hi. I need to sum in excel some values where one of the criterias is the
Employee number and the other is if the Date column is equal or bigger the is last entrance. This is the look of my Employee sheet: Employee Start 3000 05-01-2009 And I need to sum the values from this sheet: Employee Date Time 3000 01-01-2009 1:00 3000 16-01-2009 8:00 3000 26-01-2009 0:30 I need to sum in order to get this: Employee Time 3000 8:30 Can you help please? Thanks, Marco |
#2
|
|||
|
|||
Sum with IF and IF/Where
Marco wrote:
Hi. I need to sum in excel some values where one of the criterias is the Employee number and the other is if the Date column is equal or bigger the is last entrance. This is the look of my Employee sheet: Employee Start 3000 05-01-2009 And I need to sum the values from this sheet: Employee Date Time 3000 01-01-2009 1:00 3000 16-01-2009 8:00 3000 26-01-2009 0:30 I need to sum in order to get this: Employee Time 3000 8:30 Can you help please? Thanks, Marco =SUMPRODUCT(--(Employee!A2=Values!$A$1:$A$9),--(Employee!B2=Values!$B$1:$B$9),Values!$C$1:$C$9) For much more on how and why this works see http://xldynamic.com/source/xld.SUMPRODUCT.html |
Thread Tools | |
Display Modes | |
|
|