find value in A, grouped to B

  • Thread starter Thread starter Bambers
  • Start date Start date
B

Bambers

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?
 
Hi Bambers
Try
=SUMIF(A1:A100,"#6944",B1:B100)
Change the cell ranges to suit.

HTH
Michael M
 
Back
Top