find value in A, grouped to B
 

Here's what I got..

I have 15 packing slips. Each has anywhere from 1 to 14 items and the
quantity of that item shipped. The 14 items are the same items for all
orders, except not everyone got the same items and qtys. So.. I took each
packlist and typed in the item & typed the qty in the adjacent cell. I should
mention I did this across, not down, if it matters. Now I need to find each
item '#6944' and add the qty in the cell next to it for all 14 items. End
result would be to have a list of each item with the grand total shipped next
to it. Of course no two are in the same order. Figures.. Any help?

find value in A, grouped to B
 

Hi Bambers
Try
=SUMIF(A1:A100,"#6944",B1:B100)
Change the cell ranges to suit.

HTH
Michael M

"Bambers" wrote:

Here's what I got..

I have 15 packing slips. Each has anywhere from 1 to 14 items and the
quantity of that item shipped. The 14 items are the same items for all
orders, except not everyone got the same items and qtys. So.. I took each
packlist and typed in the item & typed the qty in the adjacent cell. I should
mention I did this across, not down, if it matters. Now I need to find each
item '#6944' and add the qty in the cell next to it for all 14 items. End
result would be to have a list of each item with the grand total shipped next
to it. Of course no two are in the same order. Figures.. Any help?