Spreadsheet: 48516d1247728605-need-formula-to-count-data-by-type-query
Sheet: Data

LOB | Business Type | Process Type | Sub type | 1A | 1B | 1C | 1D | 1E | 1F | 1G | 1H | 1I | 2A | 2B | 2C | 2D | 2E | 2F | 2G | 2H | 2I | 2J | 2K | TOTAL POINTS POSSIBLE | TOTAL POINTS EARNED | Score
Index | a | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
Index | a | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
Index | a | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
Index | a | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
Index | a | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
Index | a | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
Index | a | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
Index | a | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | i | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 99 | 0.99
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1
EC1 | b | p | ec | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 100 | 100 | 1