Try this:

=SUMPRODUCT(--('2008 Events'!C2:C220=Sheet2!A7),--('2008
Events'!F2:F220=Sheet2!C1))


--
Biff
Microsoft Excel MVP


"Bobbie" wrote in message
...
I am trying to do a formula that would give me a count for multiple factors
A B
Loacation name Event type

looking for a count if location= specific name and Event type=specific
This is what I have, but is not working. What am I missing. Help....

=COUNT(IF('2008 Events'!C2:C220=Sheet2!A7,IF('2008
Events'!F2:F220=Sheet2!C1,0),0))
--
Thanks, Bobbie