close
- 多條件總和: 統計同時滿足多條件的數量總和
=>SUMPRODUCT((在範圍A中滿足條件1)*(在範圍B中滿足條件2)*(...)*(在範圍M滿足條件N))
=>SUMPRODUCT((範圍A=條件1)*(範圍B=條件2)*(...)*(範圍M=條件N))
=>e.g. 滿足在BodyType中其值為Body1_1且在Result中其值為"O"的數量總和
- PassValue: SUMPRODUCT((Face1!$C:$C=Summary!$C2)*(Face1!$I:$I="O"))
=>e.g. 滿足在BodyType中其值為Body1_1且在Result中其值為"X"的數量總和
- FailValue : SUMPRODUCT((Face1!$C:$C=Summary!$C2)*(Face1!$I:$I="X"))
- 單條件總和:統計滿足單一條件的數量總和
=>COUNTIF(範圍A,條件1):在範圍A中滿足條件一的數量總和
=>e.g. 滿足在BodyType中其值為Body1_1的數量總和
- TotalNumberValue : COUNTIF(Face1!$C:$C,Summary!$C2)
| B | C | D | E | F | G |
| Category1 | Category2 | TotalNumber | Pass | Fail | Pass Rate |
| Face1 | Body1_1 | 12 | 10 | 2 | 83.33% |
| Body1_2 | 12 | 8 | 4 | 66.67% | |
| Body1_3 | 12 | 10 | 2 | 83.33% | |
| Body1_4 | 12 | 3 | 9 | 25.00% | |
| Body1_5 | 12 | 10 | 2 | 83.33% | |
| Body1_6 | 12 | 0 | 12 | 0.00% | |
| Body1_7 | 12 | 9 | 3 | 75.00% | |
| Body1_8 | 12 | 8 | 4 | 66.67% | |
| Body1_9 | 12 | 11 | 1 | 91.67% | |
| Body1_10 | 12 | 6 | 6 | 50.00% | |
| Body1_11 | 12 | 0 | 12 | 0.00% | |
| Body2_1 | 12 | 10 | 2 | 83.33% | |
| Body2_2 | 12 | 9 | 3 | 75.00% | |
| Body2_3 | 12 | 7 | 5 | 58.33% | |
| Body2_4 | 12 | 10 | 2 | 83.33% | |
| Body2_5 | 12 | 10 | 2 | 83.33% | |
| Body2_6 | 12 | 5 | 7 | 41.67% | |
| Body2_7 | 12 | 10 | 2 | 83.33% | |
| Body2_8 | 12 | 10 | 2 | 83.33% | |
| Body2_9 | 12 | 8 | 4 | 66.67% | |
| Body2_10 | 12 | 7 | 5 | 58.33% | |
| Body2_11 | 12 | 1 | 11 | 8.33% | |
| Body2_12 | 12 | 0 | 12 | 0.00% | |
| Body3_1 | 12 | 0 | 12 | 0.00% | |
| Body3_2 | 12 | 6 | 6 | 50.00% | |
| Body3_3 | 12 | 0 | 12 | 0.00% | |
| Body3_4 | 12 | 10 | 2 | 83.33% | |
| Body3_5 | 12 | 10 | 2 | 83.33% | |
| Body3_6 | 12 | 8 | 4 | 66.67% | |
| Body3_7 | 12 | 0 | 12 | 0.00% | |
| Body3_8 | 12 | 10 | 2 | 83.33% | |
| Body3_9 | 12 | 5 | 7 | 41.67% | |
| Body3_10 | 12 | 9 | 3 | 75.00% | |
| Body3_11 | 12 | 0 | 12 | 0.00% | |
| Body3_12 | 12 | 6 | 6 | 50.00% | |
| Body3_13 | 12 | 10 | 2 | 83.33% |
文章標籤
全站熱搜
留言列表
心情分享 (1)
