Open stock postion formula question

[ajr123]

I have a worksheet which extracts buy and sell info that refrence a specific stock. The buys are in one column and the sells are in antoher. However they do not line up becasue of the way they extracted What I am looking to do is creat a formula that will reference the symbol in and return the sum of the buys and sells.There may be several lines of both so I would need it to sum all buys and sells that reference that symbol.
Any help on this would be great.
Thanks!

 

[daleyman]

you might want to run a pivot table for this information.

 

[Yogi Anand]

or A DSUM function will also do the job nicely!

 

[ajr123]

I have tried the Pivot tables but in order to do what I am looking to do its too slow, I was hoping their was a formula that would do the trick.

DSUM sounds good but I am not sure how to make this work any ideas.
Thanks

 

[Yogi Anand]

Hi ajr123:
=DSUM(database,field,criteria)

database is your table reference where your data is located
field is the number of column from the left of your database which will be used for summing up
criteria is the range of cells that define the criteria that will be used to select which cells would be summed up .. this range must lie outside the table -- first row will have the field name(s), and the row(s)below will have the criteria associated with each field name
HTH!

 

[Dave Patton]

You could use Sumif

=SUMIF(rSym,A3,rBuy)-SUMIF(rSym,A3,rSell)