I have no idea how to do this and google searches have been fruitless so far. I hope someone can help.
We have a spreadsheet that goes back years. It's our company bank account right back to 2007. It has incoming and outgoing payments in the same column (just as the bank formats it - these are downloaded from online banking and I just paste the entries into my own spreadsheet.
I'd like it to total the following (and display the results in 2 separate cells).
Total incomings Monday to Friday.
Total outgoings MOnday to Friday.
the formula is going to have to identify each week, then check whether a transaction had a positive or negative value, and calculate according, then insert the incomings for the week in one cell, and the outgoings for the week in another cell.
Is this even possible???
Bookmarks