Nested IF statement on Google Spreadsheet, second part same as the first [migrated]
- by lazfish
I have a spreadsheet for my budget. Payments are either drawn from my bank or my Amex card and then my Amex card is drawn from my bank as well. So I add up all my monthly total like this:
=sumif(I3:I20,"<>AMEX",D3:D20)
Where I3:I20 = account bill is paid from and D3:D20 is monthly amount due.
So I am not including bills that come from my Amex card in the total since the Amex bill itself covers those.
Next I have a column that has the day of the month 1-10 (when everything gets paid) and it does this:
=sumif(H3:H20,E24:E33,D3:D20)
Where H3:H20 = date bill is paid and E25:E35 = range from 1-10.
What I want to do is make this second part do the same check as the first. Something like
this:
=sumif(H3:H19,E24:E33,IF(I3:I19"<>SPG",D3:D19,0))
But I get error: "Parse error"
What am I doing wrong?