What formula do you use when there may not be a value there? Like:

ITEM QTY SOLD
T0887 50 1
T0887 100
T0887 200 2
T0992 50 3
T0992 100



To get:
# of sold items for each item?
--
Nicki Taylor