I'm trying to achieve the following summary based on the data in the 'Data
table' below. I require assitance to construct a sumproduct formula that will
aggregate the blood groups correctly (e.g. A + & A - combined as A, AB + & AB
- combined as AB). I want to construct one generic formula that will
aggregate based on the blood group characters excluding the +/-.

Summary Table
Combined Blood Groups
Data Type Component A AB B O
Inventory Red Cell 10 20 40 60
Issues Red Cell 2 4 6 8

Data Table
Data Type Component ABO Qty
Inventory Red Cell A + 5
Inventory Red Cell A - 5
Inventory Red Cell AB + 10
Inventory Red Cell AB - 10
Inventory Red Cell B + 20
Inventory Red Cell B - 20
Inventory Red Cell O + 30
Inventory Red Cell O - 30
Issues Red Cell A + 1
Issues Red Cell A - 1
Issues Red Cell AB + 2
Issues Red Cell AB - 2
Issues Red Cell B + 3
Issues Red Cell B - 3
Issues Red Cell O + 4
Issues Red Cell O - 4