Forum Discussion
Drin16
Oct 27, 2021Copper Contributor
COUNT IF WITH MULTIPLE CRITERIA IN A MULTIPLE COLUMN ROW
Hi,
How could I count specific word on multiple column and rows based on 3 criteria.
Count if match with date
Count if match "BAOB"
Count if match "PENDING"
I want to count PENDING on a specific month based on BAOB team
Month can be change on drop down list
Many Thanks,
How could I count specific word on multiple column and rows based on 3 criteria.
Count if match with date
Count if match "BAOB"
Count if match "PENDING"
I want to count PENDING on a specific month based on BAOB team
Month can be change on drop down list
Many Thanks,
Drin16 I assume you are working on the Dashboard tab:
=COUNTIFS(Timesheet[Fleet],$A4,INDEX(Timesheet[#Data],,MATCH($N$3,Timesheet[#Headers],0)),C$3)