Thanks for the quick response. The sample you provided shows the same problem I am trying to solve. Matt should only show 24 hours projected for company K. The 4 and 21 are for Ken and Maya, respectively. Also, I would like the actual hours to be summed. So Matt/Company K would be 50.5 not 2 and 48.5.