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

In D2
=IF(C20,"AR",)
In E2
=IF(C20,"AP",)
Then highlight D2 to E3 and hit control d

"Tim T via OfficeKB.com" wrote:


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