seems easy but for some reason google spreadsheets is being difficult.

say i have

a b c
9-jan NBA 0
9-jan NCAAM 1.1
12-jan nfl 2.21
21-jan nfl 1.379
3-feb nfl -1.5


I want it so if i made an nfl bet in january then add the value in column c.

=SUMPRODUCT(--(A1:A1000="1"),--(B1:B1000="nfl"),c1:c1000)

that is what i have but it comes up #ERROR!