Countif or Sumproduct

[Guest]

I have three columns of data: year, month, and type. I need to count the
type based on year and month.

How to do?

Thanks

 

[Don Guillett]

try
=sumproduct((rngA=2007)*(rngB="March")*(rngC="whattype"))

 

[Guest]

are your month and year columns text or numbers or dates formatted as year
and month?
The appropriate equation depends on the answer.