Summing an item in multiple areas

[bobgrand]

Hello all,

I have a spread sheet of inventory history with sales that have the same item in multiple areas with different quantities. In another sheet I have a single list of these items. I would like to get the total sum of an item from sheet 1 to show in sheet 2.

Sheet 1 - Sales Quantities
THHN 8 SOL - 2500
THHN 10 SOL - 3000
THHN 12 SOL - 1500
THHN 10 SOL - 3500
THHN 8 SOL - 2500

Sheet 2 - Totals
THHN 8 SOL - 5000
THHN 10 SOL - 6500
THHN 12 SOL - 1500

Any help would be greatly appreciated

 

[Fluff]

Change the format of col B to Dates & what do you see?

 

[bobgrand]

I figured it out. I had the columns confused and found out locking the columns helped and gave me the exact result I was looking for. I think I just needed the interaction with you to get my wheels turning. Thank you for that.

=SUMIFS(Releases!$B$3:$B$2001,Releases!$A$3:$A$2001,DATA!B5)

 

[Fluff]

Glad you sorted it & thanks for letting us know.