I use count if =COUNTIFS('INR-CPAR Monitoring'!$K:$K,$A$3, 'INR-CPAR Monitoring'!$E:$E,C2) | | COUNTIFS('databaseMONTH,Month, 'databaseNEARMISS,Nearmiss)
and it gives me The result of like this
||||||||||||||||||||January |February
Near Miss: 5 2
now my question is. Is there any solustion to make 3 criteria . As you can see I have Month and Classification of Accident now I want to add criteria for Company.
so it will only count number of
NEAR MISS on Specific Month and Specific Company?
and it gives me The result of like this
||||||||||||||||||||January |February
Near Miss: 5 2
now my question is. Is there any solustion to make 3 criteria . As you can see I have Month and Classification of Accident now I want to add criteria for Company.
so it will only count number of
NEAR MISS on Specific Month and Specific Company?
| Month | January | February |
| Near miss | 0 | 4 |
