I just can't seem to write the formula for this one. I would appreciate assistance. I've tried to explain below what I want. Final result should be 3. I've stated criteria below - but the way I'm going about it could be wrong.
Can you help? Thank you.
Can you help? Thank you.
ID | Part | OH | Usage | Result | Column | Count if | |
1 | A | 0 | 0 | Don't Count | A | ID equals Same | |
1 | B | 0 | 0 | B | Part equals A or B | ||
2 | A | 1 | 0 | Don't Count | C | OH equals 0 for both A and B | |
2 | B | 0 | 1 | D | Usage is greater than 0 for either A or B | ||
3 | A | 0 | 0 | Count 1 | |||
3 | B | 0 | 1 | ||||
4 | A | 0 | 1 | Count 1 | |||
4 | B | 0 | 1 | ||||
5 | A | 1 | 0 | Don't Count | |||
5 | B | 0 | 0 | ||||
6 | A | 1 | 1 | Don't Count | |||
6 | B | 1 | 0 | ||||
7 | A | 1 | 1 | Don't Count | |||
7 | B | 0 | 0 | ||||
8 | A | 0 | 1 | Don't Count | |||
8 | B | 1 | 0 | ||||
9 | A | 0 | 0 | Count 1 | |||
9 | B | 0 | 1 | ||||