| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotaling a column based on three others
Hello:
I have a list of inventory items. Column A has the Item, column B has the Item Lot Number, column C has the Expiration Date, and column D has the Quantity. I want to subtotal the Quantity column for records that have the same Item, Item Lot Number, and Expiration Date. In other words, I need to subtotal column D based on A,B, and C. I am using Excel 2003. childofthe1980s |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
subtotaling a column based on three others
try this where you put the date in cell f1
=sumproduct((a2:a22="itemname")*(b2:b22=12)*(c2:c2 2=f1)*d2:d22) -- Don Guillett Microsoft MVP Excel SalesAid Software "childofthe1980s" wrote in message ... Hello: I have a list of inventory items. Column A has the Item, column B has the Item Lot Number, column C has the Expiration Date, and column D has the Quantity. I want to subtotal the Quantity column for records that have the same Item, Item Lot Number, and Expiration Date. In other words, I need to subtotal column D based on A,B, and C. I am using Excel 2003. childofthe1980s |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
subtotaling a column based on three others
Thanks, Don. Actually, the way I'm going to do it is to concatenate the
three columns, sort on the concatenated column, and do a subtotal based on it. Thanks, though, for chiming in!!! childofthe1980s "Don Guillett" wrote: try this where you put the date in cell f1 =sumproduct((a2:a22="itemname")*(b2:b22=12)*(c2:c2 2=f1)*d2:d22) -- Don Guillett Microsoft MVP Excel SalesAid Software "childofthe1980s" wrote in message ... Hello: I have a list of inventory items. Column A has the Item, column B has the Item Lot Number, column C has the Expiration Date, and column D has the Quantity. I want to subtotal the Quantity column for records that have the same Item, Item Lot Number, and Expiration Date. In other words, I need to subtotal column D based on A,B, and C. I am using Excel 2003. childofthe1980s |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Subtotaling based on more than one group | Excel Worksheet Functions | |||
| Subtotaling on column with IF statement results | Excel Discussion (Misc queries) | |||
Linear Mode
