Hi Paul,

Did not work that formula, I will write more specific as follows;

Col.A Material Col.C date Col.F arrive in Col.H dispatch out Col.J in stock
3/5/2013
Wood 15 10 5
Rice 20 15 5
sweets 10 5 5
cakes 12 4 8
fruits
3/6/2013
lumber 10 7 3
wood 15 5 10
balls 12 8 4
Rice 20 12 8
and so on
for other
days A:2500

The above values are under each column accordingly, to show how many arrived in , dispatch out and in stock for the related date.

Now I like to have in sheet2, Col.A all the material names and in Col B the respective cells which have formula to find eg. all woods in stock from diffent date and show the total in one cell as summery of that week or 10 weeks. Because when I write the repot I do want to have all in stocks added in one cell for that specific material name, and respectively for other goods are in stock too.

Regards Iraj.