Please look at the LINK provided at the bottom this is a spreadsheet.
I am trying to figure out the bills I need to pay. I am used to being paid every 2 weeks and I am on a new weekly schedule. I have decided to make a spreadsheet, to try to figure out which bills I have already transferred money for and which bills I still need to transfer money for.
Basically, I want the cell in F3 to = the F column the cell to the left, unless the cell in F9 or F10 = d, then either add the F3 column F9 E3 (if F10=d) or add the F3 column F10 E3 (if F9=d) or add the F3 column F9 F10 (if both =d).
CodePudding user response：
I have created a copy of your sheet, and tried for a bit, and that's what i got:
=IF(AND(F9="d",F10="d"),SUMIF(F6:F,"t",B6:B),IF(F9="d",SUMIF(F6:F,"t",B6:B) E3-B9,IF(F10="d",SUMIF(F6:F,"t",B6:B) E3-B10,SUMIF(F6:F,"t",B6:B) E3)))
There is probably a better way to solve this without this many IF statements, but I honestly can't help you there.
What it does is literally just check if both F9 and F10 are d, and do the sum without E3. If not, it checks only for F9 leaving it out if so, then for F10 doing the same, and at last just sums everything up if neither of them are d.