| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup and Display Using Multiple Criteria
Ken, it works great. Thanks a bunch.
GB "Ken Johnson" wrote: Oops! That only gives the January figures. Need to get rid of the $'s in the third array argument column addresses... =SUMPRODUCT(('Input Data'!$B$2:$B$10=$A$1)*('Input Data'!$C$2:$C$10=$B1)*('Input Data'!D$2:D$10)) Ken Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup with multiple criteria... please help! | Excel Worksheet Functions | |||
| Double and Multiple Lookup Using the MATCH Function | Excel Worksheet Functions | |||
| Lookup: Multiple Occurances | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Multiple table lookup | Excel Discussion (Misc queries) | |||
Threaded Mode
