Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct with partial charcter matching
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to count charcter in a range | Excel Worksheet Functions | |||
Finding a charcter in a text string | Excel Worksheet Functions | |||
Sumproduct for partial text | Excel Worksheet Functions | |||
How do I count the number of times a particular charcter ("." say) | Excel Discussion (Misc queries) | |||
sumproduct partial text count | Excel Worksheet Functions |