nburaq
Board Regular
- Joined
- Apr 2, 2021
- Messages
- 220
- Office Version
- 365
- 2019
- Platform
- Windows
Hi,
I have a table called "Table1" at Sheet2 and I would like to find the number of events occurs at specified week. I would like to learn how to count of every value in a table based on week number entered and "Planned" or "Maintenance" and as final result counting of every distinct value in a table
sheet1 A1: 8
A B C D E
My approach was in A2: =SUMPRODUCT(1/COUNTIFS(Table1[Event Desc];Table1[@[Event Desc]];Table1[Week];$A1;Table1[Accepted];"Yes";Table1[Category];{"Planned";"Maintenance"}))
Thanks for your help and concern!
I have a table called "Table1" at Sheet2 and I would like to find the number of events occurs at specified week. I would like to learn how to count of every value in a table based on week number entered and "Planned" or "Maintenance" and as final result counting of every distinct value in a table
sheet1 A1: 8
A B C D E
Category | Reason | Week | Event Desc | Accepted |
Planned | Mechanical | 8 | Day Stop | Yes |
Maintenance | Electrical | 8 | Low Gas Pressure | Yes |
Planned | Mechanical | 10 | Day Stop | Yes |
Maintenance | Electrical | 10 | Low Gas Pressure | No |
My approach was in A2: =SUMPRODUCT(1/COUNTIFS(Table1[Event Desc];Table1[@[Event Desc]];Table1[Week];$A1;Table1[Accepted];"Yes";Table1[Category];{"Planned";"Maintenance"}))
Thanks for your help and concern!