| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Where to begin???
Spiky,
That did the trick. Thanks! "Spiky" wrote: Actually, I just realized I did that formula wrong, anyway. You only wanted the sum of the days. Take out the first argument, it should just be this: =SUMPRODUCT(LOOKUP(B2:AY2,Sheet2!A1:B100)) If you got an N/A error, it probably means the database was incorrect. It returns N/A with a bad Lookup. I assumed that 5, 1, 10, 999, 220 were all job names. Was that correct? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Begin/End selectivity | Excel Worksheet Functions | |||
| How do I begin value with the number zero? | Excel Discussion (Misc queries) | |||
| I dont know where to begin :( | Excel Discussion (Misc queries) | |||
| Hmmm, where do I begin? | Excel Discussion (Misc queries) | |||
| how do i begin to use excel? | New Users to Excel | |||
Threaded Mode
