Hi Mike,

On Mar 26, 12:20 pm, Mike Morris <Mike
wrote:

the problem is that a single "line #" may be spread across many lines on the
excel sheet. (e.g. 500 pieces shipped may appear as individual entries of
125, 25, 25, 67, 38, 122, 98)

When this happens are the PO# and item # repeated?

If so, you could use a pivot table.

What I'd like to do is to "collapse" multiple lines where the value for "po#
and "line #" match (item # would then also match) and total the values for
"qty shipped" into a single line with the total # shipped.

Dan