Hi to all,

I would need some help in simplifying calculation of inventory.

COLUMN E F

PRODUCT A 20
PRODUCT B 10
PRODUCT C 10

eg. i need to count Product A which can occur multiple times throughout the whole worksheet.

I currently have 612 rows of 100 different types of products which i need to tally for my monthly stock take. it is very tedious searching for a particular product that can be on any line as COLUMN E is not in sequence. i currently do a search and manually tally the amount and my boss is killing me!

Cheers for your attention!
Clifford