"RagDyer" wrote in message
...
With the text to look up entered in D1,
And the specific number to use in C1, try this:

=SUMPRODUCT((A1:A20=C1)*(B1:B20=D1))

You are right my friend!
Using "*" instead of "," the formula becomes
four-byte shorter.

Bruno