Spreadsheet: 780216d1652351331-use-of-countifs-statement-to-count-2-types-product-countifs
Sheet: Test

S/ No | CarNo | Sub Sys. | To exclude in statistics
1 | All | TC | Do not count
2 | 25 | AC
3 | 6 | AC
4 | T30 | O
5 |  | ATC | Do not count
6 | T41 | O
7 |  | ATC | Do not count
8 | 11 | RSC
9 | T25 | O
10 |  | ATC | Do not count
11 | 6 | AC
12 | 11 | AC
1 | T8 | O | Do not count
2 | T12 | AC | Do not count
3 | T21 | CC | Do not count
4 | T3 | ATC | Do not count
5 | T20 | RSC | Do not count
6 | T20 | AP | Do not count
7 | T16 | ATC | Do not count
8 | T13 | RSC | Do not count
9 | T34 | CC | Do not count
1 | All | TC | Do not count
2 | 12 | AC
3 | 10 | TC | Do not count
4 |  | O | Do not count
5 | 9 | BS
6 | 9 | AP
1 | T8 |  | Do not count
1 | All | TC | Do not count
2 | 11 | RSC
3 | 20 | TIMS
4 | 32 | LS
5 | 2 | AP
6 | 4 | BS
1 | All | TC | Do not count
2 | 15 | RSC
3 | 2 | TIMS
4 | T39 | TC | Do not count
1 | T6 | AP | Do not count
2 | T43 | CC | Do not count
3 | T15 | O | Do not count
1 | All | TC | Do not count
2 | T22 | ATC | Do not count
3 |  | O
4 | T36 | O
5 |  | ATC | Do not count
6 | T38 | O
7 |  | ATC | Do not count
8 | 15 | RSC
9 | T23 | ATC | Do not count
10 | 16 | CC
11 | 28 | AC
12 | 25 | O
1 | T43 | BS | Do not count
2 | T43 | O | Do not count
3 | T43 | RSC | Do not count
1 | All | TC | Do not count
2 | T41 | ATC | Do not count
3 |  | O
4 | 10 | AP
5 | 38 | LS
6 | 38 | O
7 | T25 | ATC | Do not count
8 |  | O
1 | All | TC | Do not count
2 | T34 | ATC | Do not count
3 |  | O
4 | 18 | RSC
5 | T18 | DS
6 |  | ATC | Do not count
7 | T28 | ATC | Do not count
8 | 40 | CC
9 | 42 | DS
10 | 15 | FS
11 | T28 | ATC | Do not count
12 | T9 | ATC | Do not count
13 |  | O
1 | T3 | CC | Do not count
1 | All | TC | Do not count
2 | 39 | AP
3 | T40 | ATC | Do not count
4 | 30 | FS
5 | 6 | AC
6 | 43 | RSC
7 | 25 | DS
8 | T41 | O
9 |  | ATC | Do not count
10 | 16 | TC | Do not count
11 | 13 | O
12 | 24 | O
13 | 43 | O
1 | T11 | AC | Do not count
2 | T41 | O | Do not count
1 | All | TC | Do not count
2 | 16 | AC
3 | T27 | O
4 |  | ATC | Do not count
5 | 19 | TIMS
6 | 15 | CC
1 | All | TC | Do not count
2 | 29 | RSC
3 | 26 | LS
4 | 9 | O
1 | T39 | BS | Do not count
1 | All | TC | Do not count
2 | 30 | FS
3 | 16 | AC
4 | T8 | ATC | Do not count
5 |  | O | Do not count
6 | T8 | ATC | Do not count
7 | 8 | DS
8 | 26 | RSC
9 | 25 | TS
10 | 12 | AC
11 | 20 | CC
12 | 40 | CC
13 | 43 | CC
1 | T21 | CC | Do not count
2 | T8 | ATC | Do not count
3 | T25 | TS | Do not count
4 | T28 | AC | Do not count
5 | T25 | AC | Do not count
6 | T9 | TS | Do not count
7 | T10 | AP | Do not count
8 | T38 | O | Do not count
9 | T38 | O | Do not count
1 | All | TC | Do not count
2 | T26 | ATC | Do not count
3 |  | O
4 |  | TC | Do not count
5 | T32 | ATC | Do not count
6 |  | O
7 | 43 | DS
8 | 6 | RSC
1 | T40 | CC | Do not count
2 | T34 | AC | Do not count
3 | T39 | TS | Do not count
4 | T23 | RSC | Do not count
5 | T22 | AP | Do not count
6 | T15 | TC | Do not count
1 | All | TC | Do not count
2 | 18 | AC
3 | 22 | AC
4 | 4 | AC
5 | 14 | RSC
6 | 18 | BS
7 | 19 | TIMS
8 | 12 | DS
9 | 4 | BS
10 | 38 | CC
11 | T39 | ATC | Do not count
1 | T15 | TC | Do not count
2 | T13 | TC | Do not count
3 | T43 | CC | Do not count
1 | All | TC | Do not count
2 | 41 | AC
3 | T32 | ATC | Do not count
4 |  | O
5 | T42 | TC | Do not count
6 |  | RSC
7 | T13 | TC | Do not count
8 |  | VPIS | Do not count
9 | 1 | TS
10 | T24 | ATC | Do not count
11 |  | O
12 | 21 | TS
13 | T32 | ATC | Do not count
14 | T3 | TC | Do not count
15 |  | VPIS | Do not count
1 | T8 | ATC | Do not count
2 | T8 | RSC | Do not count
1 | All | TC | Do not count
2 | 33 | FS
3 | 10 | TIMS
4 | 15 | TS
5 | 30 | FS
6 | T33 | ATC | Do not count
7 |  | O
8 | T30 | ATC | Do not count
9 |  | O
10 | 20 | CC
1 | T38 | CC |  |  |  |  |  | New | 10
2 | T4 | TS
1 | All | TC | Do not count
2 | 1 | FS
3 | T1 | ATC | Do not count
4 |  | O
5 | T16 | ATC | Do not count
6 | 26 | AC
7 | 9 | BS
8 | 29 | AC
9 | 9 | BS
10
1 | T10 | O | Do not count
2 | T8 | AC | Do not count
1 | All | TC | Do not count
1 | T17 | TS | Do not count
2 | T17 | TS
3 | T1 | CC |  |  |  |  |  | Old | 9
1 | All | TC | Do not count
2 | 43 | DS
3 | T30 | ATC | Do not count
4 |  | O
5 | T41 | ATC | Do not count
6 |  | O
7 | T25 | O | Do not count
8 | 17 | RSC
9 | 12 | DS
10 | 21 | AP
11 | 21 | DS
12 | T31 | ATC | Do not count
13 |  | O | Do not count
14 | 15 | AC
1 | T20 |  | Do not count
2 | T37 |  | Do not count
3 | T34 |  | Do not count
4 | T8 |  | Do not count
5 | T6 |  | Do not count
6 | T33 |  | Do not count
7 | T9 |  | Do not count
8 | T9 |  | Do not count
9 | T32 |  | Do not count
10 | T9 |  | Do not count
1 | All | TC | Do not count
2 | T33 | ATC | Do not count
3 |  | O
4 | T41 | ATC | Do not count
5 |  | O
6 | T14 | TC | Do not count
7 | 17 | TS
8 | 17 | CC |  |  |  |  |  | Total | 19
9 | T11 | TC | Do not count
10 | 32 | CC
11 | 25 | O
12 | 22 | CC
13 | 11 | O
1 | T38 | CC | Do not count
2 | T8 | TS | Do not count
3 | T26 | O | Do not count
4 | T26 | RSC | Do not count
1 | All | TC | Do not count
2 | T19 | TC | Do not count
3 | 10 | AC
4 | 8 | AC
5 | 34 | FS
6 | 6 | CC
7 | T41 | ATC | Do not count
8 |  | O
9 | T32 | ATC | Do not count
10 |  | O | Do not count
11 | T7 | VPIS
12 |  | TC | Do not count
13 | T1 | ATC | Do not count
14 | 16 | AC
15 | 43 | CC
16 | 22 | CC
1 | T33 | ATC | Do not count
2 | T9 | BS | Do not count
1 | All | TC | Do not count
2 | T32 | ATC | Do not count
3 |  | O
4 | T33 | ATC | Do not count
5 |  | O
6 | 11 | AC
7 | T21 | TC | Do not count
8 |  | VPIS | Do not count
9 | 30 | LS
10 | 32 | CC
11 | T18 | TC | Do not count
1 | T22 | CC | Do not count
2 | T11 | O | Do not count
3 | T11 | RSC | Do not count
4 | T10 | CC | Do not count
1 | All | TC | Do not count
2 | 23 | DS
3 | 23 | VPIS
4 | 32 | CC
5 | T32 | ATC | Do not count
6 |  | O
7 | 2 | AP
8 | 23 | RSC
9 | T41 | ATC | Do not count
10 | 34 | LS
11 | 14 | TIMS
12 | T10 | ATC | Do not count
13 |  | O
1 | T8 | TS | Do not count
2 | T20 | CC | Do not count
3 | T12 | DS | Do not count
4 | T32 | TS | Do not count
1 | All | TC | Do not count
2 | 23 | AC
3 | 36 | FS
4 | 37 | LS
5 | T37 | TC | Do not count
6 |  | RSC
7 | 27 | O
1 | T31 | VPIS | Do not count
1 | All | TC | Do not count
2 | 40 | AP
3 | 15 | AC
4 | 9 | DS
5 | 43 | AC
6 | 3 | TS
1 | All | TC | Do not count
2 | 6 | FS
3 | 2 | FS
4 | 38 | FS
5 | 17 | AC
6 | 19 | AC
7 | 22 | AC
8 | T41 | ATC | Do not count
9 |  | O
10 | T32 | ATC | Do not count
11 |  | O
12 | T1 | ATC | Do not count
13 |  | O
14 | 25 | BS
15 | 25 | TS
1 | T10 | TS | Do not count
2 | T14 | AP | Do not count
3 | T14 | TC | Do not count
4 | T14 | RSC | Do not count
1 | All | TC | Do not count
2 | 6 | FS
3 | 32 | FS
4 | T25 | O
5 |  | ATC | Do not count
6 | 1 | TS
7 | 33 | DS
8 | 4 | AC
9 | 15 | AC
10 | T8 | TC | Do not count
11 | T32 | ATC | Do not count
12 |  | O
13 | T17 | VPIS
14 |  | TC | Do not count
15 | 25 | BS
16 | 15 | AC
1 | T24 | TIMS | Do not count
2 | T38 | VPIS | Do not count
1 | All | TC | Do not count
2 | 8 | TS
3 | 1 | O
4 | 18 | O
5 | 43 | CC
1 | T17 | RSC | Do not count
2 | T32 | CC | Do not count
3 | T27 | ATC | Do not count
4 | T15 | O | Do not count
1 | All | TC | Do not count
2 | 7 | O
3 | 7 | DS
4 | 7 | RSC
5 | 22 | AP
6 | 38 | AP
7 | 31 | TS
8 | 8 | AC
9 | 17 | AC
1 | T8 | CC | Do not count
2 | T1 | AC | Do not count
3 | T1 | LS | Do not count
4 | T32 | BS | Do not count
1 | All | TC | Do not count
2 | 21 | AC
3 | 18 | AC
4 | 40 | VPIS
5 | 25 | AC
6 | 21 | TS
7 | 24 | BS
8 | 3 | O
9 | 36 | O
10 | T17 | VPIS | Do not count
11 |  | TC | Do not count
1 | T21 | TS | Do not count
2 | T25 | AP | Do not count
3 | T37 | CC | Do not count
4 | T37 | O | Do not count
5 | T37 | O | Do not count
6 | T3 | RSC | Do not count
1 | All | TC | Do not count
2 | 15 | AC
3 | 39 | O
4 | T12 | TC | Do not count
5 |  | VPIS
1 | T34 | AC | Do not count
2 | T6 | AC | Do not count
3 | T25 | TS | Do not count