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:
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) d|amount due ------------------- 1|$XX.XX 2|$XX.XX 3|$XX.XX 4|$XX.XX 5|$XX.XX 6|$XX.XX …
Where H3:H20 = date bill is paid and E24:E33 = range from 1-10. What I want to do is make this second part do the same check as the first. Something like this:
But I get error: "Parse error"
What am I doing wrong?