Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
I have a part number in row a, and I want to look up the part # on an
inventory list in a separate worksheet, and have excel return the total number of that part # in stock. Right now I have: =SUMPRODUCT(--('c:\Database\[FINISHED GOODS.XLS]Finished Goods'!$A$2:$A$260=A85),'c:\Database\[FINISHED GOODS.XLS]Finished Goods'!$C$2:$C$200) A85 being the cell that contains the part # to be looked up C:\Database\[FINISHED GOODS.XLS]Finished Goods'! being the spreadsheet to lookup on, A2:A200 being the column with the part # in finished goods, and c2:c200 being the column with the number of units in stock. It is returning a #value message I hope I am not confusing you all too much. I really could use some help Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions | |||
Sumproduct | Excel Discussion (Misc queries) | |||
Like Sumproduct, But Different | Excel Worksheet Functions | |||
Sumproduct Help | Excel Worksheet Functions |