try this

=COUNT(IF((A1:A30="x")*(B1:B30="y"),))



On Sep 29, 11:05*am, smcmoran
wrote:
I have a data sheet with data listing users and a product group. *I need to
count the number of occurances where the user and group match. *so on the
second sheet i need to fill cells with the count of "IF !A:A = "X" and !B:B =
"Y"". *I have been trying countif and sumproduct with no luck. *I can get the
sum of both individual matches but not when the combination matches.

Any ideas?

Thanks
Scott