Unfortunately, I'm not seeing the big picture either (remember, no one
online here knows how your business model works unless you tells us in
detail). For example, you have this...

0068612133 1 0068612722 17
0068612133 1 0068611051 0

and you say the "answer" is 18 (1+17). Why? There are two 1's, a 0 and a 17
associated with the 0068612133 number in Column A... which "1" is being
added to the 17 and why is the other one being ignored? Or am I misreading
where the 1 is coming from?

--
Rick (MVP - Excel)


"Sergio" wrote in message
...
Thank you Susan, but if you see the latter example, the qty=1 + 17 = 18 in
total. If i add them the way you tell me, i would get 19 in total. Also,
sometimes i can have as many as 23 substitute part numbers, each one with
it's own qty but the original part will still have the same qty row after
row.

"Susan" wrote:

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,