MT wrote:
I want a summary count of two criteria. (count if type = a and class
=1)

In one column type is stored and in another column Classification is
stored.

I want the know how many type a, classification 1 exist

I was trying to use countif, but can't seem to figure out how to do
it for two criteria. can you use AND??

=COUNTIF(Sheet1!E:E,"IC")

You say that your criteria are a and 1 yet your COUNTIF contains IC???

Are your types and classes in separate columns? If so where?

What actually are your criteria values?