pliskers
Active Member
- Joined
- Sep 26, 2002
- Messages
- 461
- Office Version
- 2016
- Platform
- Windows
I have a list of items on Sheet 1 (column A), and a data table on Sheet 2 with item names in col A and values in col B.
I'd like an array formula that would deliver, in a single cell, the total of all records in column B on Sheet 2 that match ANY of the items in my list in col A Sheet 1.
I think I've described this clearly enough to hopefully not have to provide a data sample. Would greatly appreciate a sample formula. Many thanks!
I'd like an array formula that would deliver, in a single cell, the total of all records in column B on Sheet 2 that match ANY of the items in my list in col A Sheet 1.
I think I've described this clearly enough to hopefully not have to provide a data sample. Would greatly appreciate a sample formula. Many thanks!