View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robert morris robert morris is offline
external usenet poster
 
Posts: 222
Default Time Sheet - Hlookup, Index, SumProduct or what?


In Col's C4:I4 have Mon thru Sun

In C5:I5 have store ID's i.e., "NL" and "JP" which can move to
different days from week to week.

Have hours for each day in C9:I9 related to store ID.

Need to Sum the hours for "NL" in J6 and Sum hours for "JP" in J9

Thanks for the help

Bob