Countif help
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
|