Spreadsheet: 153874d1336075804-excel-2007-countifs-using-variable-to-identify-column-referenced-countifs-from-rangev2
Sheet: Data

 |  |  | Completion Day | system impacts
Data set 1 - original data set, each feature gets a row |  |  |  | system 1 | system 2 | system 3 | system 4 | system 5 | system 6 | system 7 | system 8 | system 9 | system 10
 | capability 1 | feature 1 | Mon | H |  | M
 | capability 1 | feature 2 | Wed |  |  | H
 | capability 2 | feature 3 | [NAME] |  |  | H | H
 | capability 3 | feature 4 | Fri |  | L
 | capability 4 | feature 5 | Thurs |  |  |  |  | H |  | M
 | capability 4 | feature 6 | [NAME] | H | M | M |  |  | M | M
 | capability 4 | feature 7 | Wed |  | H | H |  |  | H | H
 | capability 8 | feature 8 | [NAME] |  | H | H | H |  | H | H
 | capability 9 | feature 9 | mon |  | L
 | capability 10 | feature 10 | mon |  |  |  |  | H |  | M
or
 |  | Completion Day |  |  |  |  | system impacts high |  |  |  |  |  |  |  |  |  | system impacts medium |  |  |  |  |  |  |  |  |  | system impacts low
Data set 2 - summing feature counts by capability and limiting by department |  | Mon | [NAME] | Wed | Thurs | Fri | system 1 | system 2 | system 3 | system 4 | system 5 | system 6 | system 7 | system 8 | system 9 | system 10 | system 1 | system 2 | system 3 | system 4 | system 5 | system 6 | system 7 | system 8 | system 9 | system 10 | system 1 | system 2 | system 3 | system 4 | system 5 | system 6 | system 7 | system 8 | system 9 | system 10
 | capability 1 | 2 |  |  |  |  | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | capability 2 |  |  | 1 |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | capability 3 |  | 1 |  |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | capability 4 |  |  |  |  | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | capability 5 |  |  |  | 2 |  | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | capability 6 |  | 3 |  |  |  | 2 | 1 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1
 | capability 7 |  |  | 4 |  |  | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2
 | capability 8 |  | 1 |  |  |  | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2
 | capability 9 | 2 |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | capability 10 | 2 |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0
 |  |  |  |  | Working [NAME]
 |  |  |  |  |  | system 5 | system 3 | system 7 | << Data Validation list
 |  |  |  |  | Mon
 |  |  |  |  | [NAME] | * |  |  |  | *this cell should count the number of occurences of G32 by completion day F34
 |  |  |  |  | Wed
 |  |  |  |  | Thurs
 |  |  |  |  | Fri
 |  |  |  |  | total