Thread: Sum if two varialbles (sum if and if)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Sum if two varialbles (sum if and if)
=SUM(IF(EmployeeNumber=EmployeeNumber)*(Date=Admi ssionDate),NumberOfHours,))

array-enter it = CTRL+SHIFT+ENTER

Reply With QuoteReply With Quote