View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
childofthe1980s childofthe1980s is offline
external usenet poster
 
Posts: 122
Default 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