COUNT IF WITH MULTIPLE CRITERIA IN A MULTIPLE COLUMN ROW

[Drin16]

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,

[#2 · Accepted solution]

@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)

[#3]

@Drin16 

See the attached version.

[#4]

Thank you @mtarler & @hans both of you gave me the best format/formula. 👌🏻