If I understand correctly, you want the value in column F to indicate the
accumulated total (running total) of the amounts in column A for a particular
part number (which is in another, unspecified column? I will have to use that
column, so I will arbitrarily make it column C). You could use a worksheet
formula such as this in your F column - it is written for F2; could be copied
down in column F to work for the rest of the range - but only if you follow
the relative/absolute references carefully:
F2 = SUMIF($C$1:$C2,$C2,$A$1$A2)

"EED" wrote:

I'm able to get a two cell accumlator going but my problem is I have multiple
lines that I need this for.

Ex: A1(amt entered) F2(accum. total), which goes from A1 & F2 thru A500
& F500

These totals are for each line/part number for whats being shipped out, with
keeping overal total for what has been shipped for that part.

I've been looking at different codes but havent found the information needed
to make this happen. Hopefully it can but please advise with any assistance.
Thanks!!!!