Thread: Sum with IF and IF/Where
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
  
Posts: 915
Default 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
Reply With QuoteReply With Quote