bobgrand
Board Regular
- Joined
- Apr 14, 2008
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
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
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