Sumproduct error

HI ALL

I am trying to sum few columns based on a single criteria using sumproduct formula.

Formula:

=SUMPRODUCT((D10:D250=D37)*(BZ10:CC250))

The above formula gives me error. However when I change "CC250" to "CA250" I am getting correct answer.

I even tried putting two minus signs but no avail.

Formula:

=+SUMPRODUCT(--(D10:D250=D37)*(BZ10:CC250))

Any guess why I am getting error.