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