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!
Any help on this would be great.
Thanks!