=sumproduct((a2:a200="New York")*(b2:b200={"Baseball","Football"}))

--
Don Guillett
SalesAid Software

"D VanD" wrote in message
...
I can't find anything in the help. I need to be to count more than one
criteria. Is this possible?

As an example.

A B
1 New York Baseball
2 New York Football
3 Cincinnati Baseball
4 Cleveland Baseball

I want to be able to display this in another workbook

B C
Baseball Football
1 New York 1 1
2 Cincinnati 1 0
3 Cleveland 1 0

So as an example, what formula can I use in cell B1 to count both
criteria,
both New York and baseball.

Thanks in advance
Doug