If that's the case, which I don't believe it is,

You've got text or formula returned errors then in the range,
which you didn't exactly reveal in your orig. posting
It would have worked otherwise.

Does this convince you that it works? :
http://www.freefilehosting.net/download/3a3j8

.. why did the other formula work?
why doesn't daddy respond to you?

note that I never said daddy's formula didn't work

my question to you is:
why were you using a *sumproduct* formula originally?