Thread: Countif ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MT
 
Posts: n/a
Default Countif ?

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")