Parameters:
Column A = Text
Column B = Text
Column C = Numerical

My formula is:

=SUMPRODUCT((Data!$A$2:$A$32001=Sheet2!$A3)*(Data! $B$2:$B$32001=H$1),Data!$C$2:$C$32001)

This works fine except where the value/text I want returned in column C
looks like this "2008: 36" or "2008-36" - instead I receive "0" or "84" -
when I want the formula to return exactly what is in the cell.

Please help!!!