Below is what I have on a spreadsheet. I need sum up the P&L values for each
period (month) by counterparty. If the sum is positive it is an AR, If
negative an AP. Anyone know a quick way to do this?






Period Counterpart P/L AR AP
Jul-05 Coke 5000
Jul-05 Coke 10000