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
|