Hi All,



I want to creat an inventory list in sheet 1, where I have hundreds of different goods`every day arrive in warehouse and goes out the same day or other days in a week. But in sheet 2 I want to have a summery of the remaining goods available in my warehouse to report.

Which formula should I use in sheet 2 that can search the same material name in say Column A sheet 1 but arrived in different time in a same day or week, and find the related value in stock in say column F respective rows, to have all added values of one material in one cell in sheet 2 automatically calculated.

Cheers Iraj.