I want to SUM the dollars from multiple stock transactions involving multiple stocks over several months. My excel columns (only two) are TICKER and LEG NET. (Examples: ticker xyz leg net -250, that would be Row 1 in Excel. Row 2 might be: ticker abc leg net +300. Row 3 might be: ticker abc leg net -100. There are a couple hundred rows and sometimes a ticker is repeated (perhaps 3 or more times with the same ticker but different leg net values). Some tickers entries are "one of a kind" and not entered thereafter. Nothing alphabetized (i.e. ticker), nothing arranged specially, just multiple rows of data. Some some ticker entries are the same ticker but the leg net is usually not a repeat amount. How can I get a tally of the total NET for each ticker (abc above would TALLY NET as 200 (300 less 100 = 200).
6 freelancers are bidding on average $34 for this job
Hi, this is very simple, and there are 2 ways to do this, if you are interested in working with me, please message me so i can explain in more detail. I can complete this right now (start immediately). Thanks, Milan