COUNTIFS with 3 sets of criteria.

[In a pickle]

Hullo again!

I'm attempting to write a formula that counts how many entries are in a given worksheet based upon three (3) different sets of criteria. I'm attaching a sample workbook.

To sum it up, in the Util Flakes worksheet, I need to count how many cells have data based on:
Criteria 1: Count the data in Util Flakes only if the data in cell $A6 in Lithics Analysis equals the data in column I in Util Flakes (e.g., Gray Chert, Gray Chert)
Criteria 2: Count criteria 1 ONLY if the data in the Util Flakes equals "Y" in Column T
Criteria 3: Count criteria 1 & 2 ONLY if the criteria in column J (Util Flakes) ='Y"

I've tried using COUNTIFS, multiple IF statements, and did much internet browsing with no understanding of how to accomplish this.

Any help is greatly appreciated.

[FDibbins]

This worked for me?

=COUNTIFS('Util Flakes'!$I:$I,'Lithics Analysis'!$A6,'Util Flakes'!$T:$T,"Y",'Util Flakes'!$J:$J,"Y") (gives 4)

[In a pickle]

Thank you Ford (again)!

I guess I was 'there' but couldn't figure out why I kept getting a value error.
If I was to add a fourth criteria to this statement would I follow the same format?

[JohnTopley]

Try this .... untested

=COUNTIFS(I:I,'Lithics Analysis'!A6,T:T,"Y",J:J,"Y") in sheet Util Flakes (not sure which column but tested in in AD with result of 4.

[JohnTopley]

... yes ,... just keep adding criteria as required.

[FDibbins]

Correct. COUNTIFS() syntax is...
=COUNTIFS(criteria-range1,criteria1,criteria-range2,criteria2,criteria-range3,criteria3,..............................)