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 speci...
- Oct 27, 2021
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)