I need a formula to total-up couple hundred rows of 2 column data
$10-30 USD
Completed
Posted over 4 years ago
$10-30 USD
Paid on delivery
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).
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
Hi there, Am a professional accountant in KSA, who has more than 6 years of REAL experience. With high Ms excel, research and finance management knowledge. Can offer you free samples and perfect results at a fair price. Please, feel free to contact me. Thanks