Hello,
Can you help me?
I'm designing a dashboard . In fact, dashboard's cells content more conditions and so, i use countifs function . However, when i insert this function, it return zero.
So, i don't evolve. Example: =COUNTIFS(Operations!B4:B815,$B$9,Operations!G4:G815,$C$9,Operations!M4:M815,$F$8,Operations!L4:L815,$E$9)
Bellow, i attach file.
Wait for solution
Can you help me?
I'm designing a dashboard . In fact, dashboard's cells content more conditions and so, i use countifs function . However, when i insert this function, it return zero.
So, i don't evolve. Example: =COUNTIFS(Operations!B4:B815,$B$9,Operations!G4:G815,$C$9,Operations!M4:M815,$F$8,Operations!L4:L815,$E$9)
Bellow, i attach file.
Wait for solution
Report_Observation_CVS.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | |||
1 | RAPPORT DES OPERATIONS DE CONTROLE: BLUE ENERGY - SNEL | |||||||||
2 | Statistique en % | |||||||||
3 | Remise en état | 10% | ||||||||
4 | Deconnecter | 56% | ||||||||
5 | Installer | 76% | ||||||||
6 | ||||||||||
7 | CVS | REFUS | Nbr | ACTIONS | NOMBRE DE COMPTEURS INSTALLER PAR | |||||
8 | Par agent BE | Par agent SNEL | Par agents BE et SNEL | SNEL / Menaces | ||||||
9 | DELVAUX | Refus de remise en état | 18 | Remise en état | 0 | |||||
10 | ||||||||||
11 | Deconnecter | 0 | ||||||||
12 | ||||||||||
13 | Refus d'accès au contrôle | 22 | Controler | |||||||
14 | Remise en état | 0 | ||||||||
15 | Deconnecter | 0 | ||||||||
16 | Refus d'installation | 93 | Installer | 0 | ||||||
17 | Deconnecter | 0 | ||||||||
Rapport |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F9 | F9 | =COUNTIFS(Operations!B4:B815,$B$9,Operations!G4:G815,$C$9,Operations!M4:M815,$F$8,Operations!L4:L815,$E$9) |
F11 | F11 | =COUNTIFS(Operations!B6:B817,$B$9,Operations!G6:G817,"Refus de remise en état ",Operations!M6:M817,"Par agent BE",Operations!L6:L817,"Remise en état") |
D9 | D9 | =COUNTIFS(Operations!B4:B815,Rapport!B9,Operations!G4:G815,Rapport!C9) |
D13 | D13 | =COUNTIFS(Operations!B4:B815,Rapport!B9,Operations!G4:G815,"=Refus d'accès au contrôle") |
D16 | D16 | =COUNTIFS(Operations!B4:B815,Rapport!B9,Operations!G4:G815,"=Refus d'installation") |
F14:F17 | F14 | =COUNTIFS(Operations!B8:B819,$B$9,Operations!G8:G819,"Refus de remise en état ",Operations!M8:M819,"Par agent BE",Operations!L8:L819,"Remise en état") |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
I3:I5 | Other Type | DataBar | NO | |
H3 | Other Type | Icon set | NO |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
B9:B17 | List | =Societes!$A$2:$A$6 |
F8 | List | =Societes!$D$2:$D$5 |