=SUMPRODUCT(--(B1:B4="match"),--(C1:C4=10))

Mangesh



"Mangesh Yadav" wrote in message
...
=SUMPRODUCT(--(B1:B4="match"),(C1:C4=10))

Mangesh



"NLithgow" wrote in message
...
Trying to count number of occurences when cost centre is matched and
variable
is greater than a certain amount for an entire list