Index Match Sum?????

[coccio]

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?

 

[maxflia10]

This message was edited by maxflia10 on 2002-10-17 11:23

 

[Mark W.]

Why not use a PivotTable?

Book1
	A	B	C	D	E	F	G	H	I	J
1	FundCodes	Transaction	Proceeds		SumofProceeds	Transaction
2	07	Buy	$5,000.00		FundCodes	Buy	Sell	GrandTotal
3	07	Buy	$75,000.00		07	$80,000		$80,000
4	25	Sell	($4,500.00)		25	$5,000	($4,500)	$500
5	25	Buy	$5,000.00		GrandTotal	$85,000	($4,500)	$80,500
6
Sheet3

This message was edited by Mark W. on 2002-10-17 11:24

 

[coccio]

Works great Thanks