Sorry Carim but using *-- won't do anything, that's just mixing syntaxes for
no good reason.

Dennis - most likely cause is probably #REF! errors somewhere in your
data...search and eliminate

"Carim" wrote:

Hi Dennis,

To be on the safe side, and avoid formatting issues :

=SUMPRODUCT(--('ALL FF TLING'!$D$2:$D$1200=A$9)*--('ALL FF
TLING'!$C$2:$C$1200=A10))


HTH
Carim