Countif or Sumproduct
 

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
--
Tom

Countif or Sumproduct
 

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

--
Don Guillett
SalesAid Software

"Tom" wrote in message
...
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
--
Tom

Countif or Sumproduct
 

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

"Tom" wrote:

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
--
Tom