nburaq
Board Regular
- Joined
- Apr 2, 2021
- Messages
- 222
- Office Version
- 365
- 2019
- Platform
- Windows
Hi ,
I am trying to create equivalent of Countif and Sumproduct as a "Measure" in Excel If it is possible. I have a table called Table1 and End Result will be displayed at "Acceptance" column as "Yes" or "No" based on the condition specified below;
If Occurence is >=4 or Total Lost Hour is >=8
For Occurence : =COUNTIF($A$2:$A$28;$A2)
For Total Lost Hour: =SUMPRODUCT(--($A$2:$A$29=$A2);$B$2:$B$29)
For Acceptance:=IF(OR([@Occurrence]>=4;[@[Total Lost Hour]]>=8);"Yes";"No")
Thanks for your help and comments!
I am trying to create equivalent of Countif and Sumproduct as a "Measure" in Excel If it is possible. I have a table called Table1 and End Result will be displayed at "Acceptance" column as "Yes" or "No" based on the condition specified below;
If Occurence is >=4 or Total Lost Hour is >=8
Event | Lost Time | Occurrence | Total Lost Hour | Acceptance |
A1 | 0,1 | 1 | 0,1 | No |
A2 | 0,2 | 5 | 12 | Yes |
A3 | 0,3 | 1 | 0,3 | No |
B1 | 0,4 | 1 | 0,4 | No |
B2 | 0,5 | 1 | 0,5 | No |
B3 | 0,6 | 1 | 0,6 | No |
C5 | 0,7 | 2 | 2,9 | No |
C7 | 0,8 | 1 | 0,8 | No |
C8 | 0,9 | 1 | 0,9 | No |
A2 | 1 | 5 | 12 | Yes |
D1 | 1,1 | 1 | 1,1 | No |
D2 | 1,2 | 2 | 3,5 | No |
D3 | 1,3 | 2 | 3,8 | No |
E4 | 1,4 | 2 | 3,8 | No |
E5 | 1,5 | 1 | 1,5 | No |
E6 | 1,6 | 1 | 1,6 | No |
A2 | 1,7 | 5 | 12 | Yes |
F7 | 1,8 | 2 | 8,8 | Yes |
F7 | 7 | 2 | 8,8 | Yes |
F9 | 2 | 1 | 2 | No |
A2 | 2,1 | 5 | 12 | Yes |
C5 | 2,2 | 2 | 2,9 | No |
D2 | 2,3 | 2 | 3,5 | No |
E4 | 2,4 | 2 | 3,8 | No |
D3 | 2,5 | 2 | 3,8 | No |
F4 | 2,6 | 1 | 2,6 | No |
A2 | 3 | 5 | 12 | Yes |
A2 | 4 | 5 | 12 | Yes |
For Occurence : =COUNTIF($A$2:$A$28;$A2)
For Total Lost Hour: =SUMPRODUCT(--($A$2:$A$29=$A2);$B$2:$B$29)
For Acceptance:=IF(OR([@Occurrence]>=4;[@[Total Lost Hour]]>=8);"Yes";"No")
Thanks for your help and comments!