subtotaling a column based on three others

C

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
 
D

Don Guillett

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top