um, maybe i'm not understanding the big picture, but in another column
why can't you have:
=b2+d2
=b3+d3
=b4+d4
etc.?
that seems like it would give you your total. you could even put it
in a column waaaay out if you don't want it to interfere with this
data.
just a thought
susan



On Aug 11, 3:13*pm, Sergio wrote:
Hi, I have the below data sample:
A * * * * * * * * * * * * * * B * * * * * * * * * * * * C * * * * * * * * * *
* * D
PRT * * * * * * * * *STK * * * *SUB_SUB_PART * *SUBSTK
0068605568 * * *0 * * * 4970450487 * * *0
0068605726 * * *0 * * * 4970450826 * * *16
0068605734 * * *0 * * * 0068611051 * * *0
0068612133 * * *1 * * * 0068612722 * * *17
0068612133 * * *1 * * * 0068611051 * * *0
0068612409 * * *0 * * * 0068603220 * * *0
0068612409 * * *0 * * * 0068605046 * * *0
0068612721 * * *4 * * * 0068612132 * * *3
In this case, there is a part number (column A), quantity of this part (B),
substitute part number (C), and quantity of the substitute.
For instance, part 0068605568, has qty=0 and a subst. 4970450487 also with
qty=o.
Part 0068612133 with qty=1 and a subst. 0068612722 with qty=17, and another
subst. 0068611051 with qty=0.

My question is, how do i know how many parts i have between the part number
and it's substitutes. In the latter case i would have a total of 1+17 parts.
Thanks,