I have date, Qty code & Quantity.
08-03-2007 1 X 40 1
11-03-2007 2 X 20 2
11-03-2007 8 X 20 8
14-03-2007 1 X 20 1
30-03-2007 1 X 20 1
18-03-2007 1 X 20 1
18-03-2007 2 X 20 2
18-03-2007 1 X 20 1
21-03-2007 2 X 20 2

Note-The qty in the 3dr colm are got by simply placing the formula
=MID(A2:A$9,1,1) But I need formula to sum Qty date wise. And important is
that to avoid result repetition where the date repeats in some cells. Help me
please.