Yes, as I said, use a pivot Table.

You can get a unique list with an advanced filter under the data menu

You could do it with formulas, but not sure when you want it to happen - do
you want the "form" to automatically calculate.

--
Regards,
Tom Ogilvy

"Cindy Findley" wrote in message
...
I responded once but got an error message, so apologies if this shows up
twice.

The problem is that I never know ahead of time what the items will be.
It's a tile installation pick ticket pulling products & quantities from a
work order template. It's different every time. Without knowing ahead of
time what will be on the list, is there a way to automatically summarize the
items to pick? That is, I can't have 3 lines of the same grout color &
expect the warehouse to add them up on their own. And unfortunately, I know
nothing about VBA. Thanks!