Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to lookup item for Qty?
I currently have a sheet with the following;
A (Items) B C D E Glasses - -- - 50 Vests --- -- - 10 Hats -- -- - 45 Glasses -- -- - 20 Hats -- -- - 45 Etc, I need a formula if possible to lookup just Glasses in the column and return total Qty, Hats total qty...etc, etc. Its sort of like an Inventory sheet but I enter in as purchased nothing comes out in this sheet and at the end of the month I just want to know how many in total of the specific item purchased. Thanks; |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to lookup item for Qty?
Try this:
=SUMIF(A2:A6,"glasses",E2:E6) Better to use a cell to hold the criteria: G2 = Glasses =SUMIF(A2:A6,G2,E2:E6) -- Biff Microsoft Excel MVP "tb" wrote in message ... I currently have a sheet with the following; A (Items) B C D E Glasses - -- - 50 Vests --- -- - 10 Hats -- -- - 45 Glasses -- -- - 20 Hats -- -- - 45 Etc, I need a formula if possible to lookup just Glasses in the column and return total Qty, Hats total qty...etc, etc. Its sort of like an Inventory sheet but I enter in as purchased nothing comes out in this sheet and at the end of the month I just want to know how many in total of the specific item purchased. Thanks; |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to lookup item for Qty?
Here is another way to do it assuming the title in A1 is Items and row 1 has
titles, In an empty cell enter Items and below it the item you want to find, then use the formula: =DSUM(A1:E6,E1,H1:H2) where H1 has the repeat of the title in A1 and H2 is the item you want to find. -- If this helps, please click the Yes button Cheers, Shane Devenshire "tb" wrote: I currently have a sheet with the following; A (Items) B C D E Glasses - -- - 50 Vests --- -- - 10 Hats -- -- - 45 Glasses -- -- - 20 Hats -- -- - 45 Etc, I need a formula if possible to lookup just Glasses in the column and return total Qty, Hats total qty...etc, etc. Its sort of like an Inventory sheet but I enter in as purchased nothing comes out in this sheet and at the end of the month I just want to know how many in total of the specific item purchased. Thanks; |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Item Lookup | Excel Worksheet Functions | |||
Multiple Item Lookup | Excel Worksheet Functions | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
ADD AN ITEM IN A FORMULA ONLY IF IT IS A NEGATIVE | Excel Worksheet Functions | |||
formula for item no. | Excel Discussion (Misc queries) |