I have a question I need a formula and I’m a little confused how this can be done.
This is the example:
In Column A is my Fund Codes
Cell A2: 07
Cell A3: 07
Cell A4: 25
Cell A5: 25
In Column B is my Transaction type:
B2: Buy
B3: Buy
B4: Sell
B5: Buy
In column C is my proceeds
C2: $5000.00
C3: $75000.00
C4: -$4500.00
C5: $5000.00
What I want to do is for each fund code total up the total buys in column C in one cell and total up the total sells for each fund code in another cell.
How is that done?
This is the example:
In Column A is my Fund Codes
Cell A2: 07
Cell A3: 07
Cell A4: 25
Cell A5: 25
In Column B is my Transaction type:
B2: Buy
B3: Buy
B4: Sell
B5: Buy
In column C is my proceeds
C2: $5000.00
C3: $75000.00
C4: -$4500.00
C5: $5000.00
What I want to do is for each fund code total up the total buys in column C in one cell and total up the total sells for each fund code in another cell.
How is that done?