SOLVED

COUNT IF WITH MULTIPLE CRITERIA IN A MULTIPLE COLUMN ROW

%3CLINGO-SUB%20id%3D%22lingo-sub-2890377%22%20slang%3D%22en-US%22%3ECOUNT%20IF%20WITH%20MULTIPLE%20CRITERIA%20IN%20A%20MULTIPLE%20COLUMN%20ROW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2890377%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EHow%20could%20I%20count%20specific%20word%20on%20multiple%20column%20and%20rows%20based%20on%203%20criteria.%3CBR%20%2F%3E%3CBR%20%2F%3ECount%20if%20match%20with%20date%3CBR%20%2F%3ECount%20if%20match%20%22BAOB%22%3CBR%20%2F%3ECount%20if%20match%20%22PENDING%22%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20count%20PENDING%20on%20a%20specific%20month%20based%20on%20BAOB%20team%3CBR%20%2F%3E%3CBR%20%2F%3EMonth%20can%20be%20change%20on%20drop%20down%20list%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20Thanks%2C%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2890377%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2890474%22%20slang%3D%22en-US%22%3ERe%3A%20COUNT%20IF%20WITH%20MULTIPLE%20CRITERIA%20IN%20A%20MULTIPLE%20COLUMN%20ROW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2890474%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1197469%22%20target%3D%22_blank%22%3E%40Drin16%3C%2FA%3E%26nbsp%3B%20I%20assume%20you%20are%20working%20on%20the%20Dashboard%20tab%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DCOUNTIFS(Timesheet%5BFleet%5D%2C%24A4%2CINDEX(Timesheet%5B%23Data%5D%2C%2CMATCH(%24N%243%2CTimesheet%5B%23Headers%5D%2C0))%2CC%243)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2890479%22%20slang%3D%22en-US%22%3ERe%3A%20COUNT%20IF%20WITH%20MULTIPLE%20CRITERIA%20IN%20A%20MULTIPLE%20COLUMN%20ROW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2890479%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1197469%22%20target%3D%22_blank%22%3E%40Drin16%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2895128%22%20slang%3D%22en-US%22%3ERe%3A%20COUNT%20IF%20WITH%20MULTIPLE%20CRITERIA%20IN%20A%20MULTIPLE%20COLUMN%20ROW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2895128%22%20slang%3D%22en-US%22%3EThank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%20%26amp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F21903%22%20target%3D%22_blank%22%3E%40hans%3C%2FA%3E%20both%20of%20you%20gave%20me%20the%20best%20format%2Fformula.%20%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%4046260791481EF46214BC62A15D3F66B6%2Femoticons%2F1f44c_1f3fb.png%22%20alt%3D%22%3Aok_hand%3A%22%20title%3D%22%3Aok_hand%3A%22%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor
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,
3 Replies
best response confirmed by Drin16 (New Contributor)
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)

@Drin16 

See the attached version.

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