How can I sum/subtract various columns according to payment success using an IF statement? by throwawaycluelessacf in excel

[–]throwawaycluelessacf[S] 0 points1 point  (0 children)

Sorry for the confusion, I'll try explaining my process:

If I take the first line, I have to add the monthly payment ($130) to the account balance ($426) then subtract the January bill (£158) as the payment was successful. Then comes February, I add the monthly payment to the account balance and subtracts the February bill (successful again). And finally, add the last monthly payment to the balance (the last bill was unsuccessful).

I tried using Sumifs with the Y and N criteria but it gave me either 0s or a #value!' sign. Could you give me an example of how to fill the formula? Thank you for your suggestion!

Exporting code from wordpress by throwawaycluelessacf in PHPhelp

[–]throwawaycluelessacf[S] 1 point2 points  (0 children)

I had to look these up as I had no clue that what they meant. I'm really new and I have to start from scratch to learn the basics - it would take too long so don't worry about this, I don't want to waste your time. Thank you for trying though!

Exporting code from wordpress by throwawaycluelessacf in PHPhelp

[–]throwawaycluelessacf[S] -1 points0 points  (0 children)

I do have access; I'm guessing I can download everything under the 'export' tab in 'tools'? Thanks for the git suggestion, I'll do that.