subtotaling a column based on three others

[childofthe1980s]

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

 

[Don Guillett]

try this where you put the date in cell f1
=sumproduct((a2:a22="itemname")*(b2:b22=12)*(c2:c22=f1)*d2:d22)

 

[childofthe1980s]

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]

Gee, that sounds like fun.