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???