Thread: counting how many employees are scheduled to work by hour
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_37_] barry houdini[_37_] is offline
external usenet poster
  
Posts: 10
Default counting how many employees are scheduled to work by hour
Try like this

=SUMPRODUCT((($B$3:$B$24<=$A36)+($C$3:$C$24=$A37) +($B$3:$B$24$C$3:$C
$24)=2)+0)

regards, daddy
Reply With QuoteReply With Quote