Apr 30 2024 06:24 AM
I would like to automatically SUM values for an "item" e.g. A (below) that contains a series of costs from multiple entries on another sheet
SHEET 1 SHEET2
STOCK ITEM TOTAL COST ITEM USED USED COST
A (sum from used costs) A 12
B (sum from used costs) B 10
C (sum from used costs) A 6
A 3
C 2
C 4
A 2
Many Thanks
Jeff