Thread: Countif help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clay Clay is offline
external usenet poster
 
Posts: 29
Default 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