| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with HLOOKUP/INDEX/MATCH | Excel Worksheet Functions | |||
| vlookup, sumproduct, hlookup, index match, not sure | Excel Discussion (Misc queries) | |||
| Replacing the row index in HLOOKUP | Excel Worksheet Functions | |||
| Index / Hlookup | Excel Worksheet Functions | |||
| INDEX,VLOOKUP HLOOKUP ? | Excel Worksheet Functions | |||
Threaded Mode
