If conditions in 2 columns are true then add 3rd column

[traggs25]

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!

[jeffreybrown]

Just like yesterday, never messed with Google spreadsheets so don't know what will or won't work, but this is what works in a normal sheet...

The MONTH of Jan equals 1

=SUMPRODUCT(--(MONTH(A1:A1000)=1),--(B1:B1000="nfl"),C1:C1000)

As an answer, this formula produces >> 3.589

[traggs25]

yea google sucks I guess. coming up with parse error

Any other suggestions?

[jeffreybrown]

Does the month function work at all?

Place a date in a cell and then try =MONTH(C1).

What do you get?