Assuming Data table Sheet1) is columns A&B and first formula for Summary
table (Sheet2) is in B2:

=SUMPRODUCT(--(Sheet1!$A$2:$A$100)=B$1),--(Sheet1!$B$2:$B$100)=$A2))

B1=Tool size e.g EWR - 4.75
A2="Catalog".

Copy a across and down (one row) your Summary table

Grand Total can be a simple SUM.

HTH

"Clay" wrote:

I have data I want to perform a countif based on certian criteria. I want to
count the Catalog and Non-Catalog parts for each Tool Size. I have a table
that can use the formula's to choose the Tool Size and I want to count the
Catalog vs. Non- Catalog parts found for that tool size. I will show my data
table and my summary table where I want to perform the counts.

Data table:
Tool_Specific Catalog Category
EWR - 4.75 Catalog
ALD - 4.75 Catalog
CTN - 8 Non-Catalog
EWR - 4.75 Non-Catalog
EWR - 4.75 Non-Catalog
EWR - 4.75 Catalog

Summary Table:
Catalog Category EWR - 4.75 ALD - 4.75 CTN - 8
Catalog
Non-Catalog
Grand Total