In Progress

I need a formula to total-up couple hundred rows of 2 column data

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).

Skills: Excel, Data Processing, Data Entry, Mathematics, Statistics

See more: i have 12 scanned images and each one has 30 rows and 15 column i need you will type the data from images to excel, i have 2 codes that i need someone to decipher, i have 36 statements that i need entered into excel the maximum number of entries per statement is 86 rows and two columns one c, how to sum multiple rows and columns in excel, how to sum multiple rows in excel, how to sum multiple columns in excel, how do i apply a formula to visible cells only in excel?, how to get sum of filtered data in excel, excel sum exclude hidden cells, excel formulas, how to sum only filtered (visible) cells in excel, i need 2 images for diwali discount to sell computer parts, i need 2 t-shirt design with name keep, i need 2 t-shirt design with name, i need 2 tshirt design with name keep, i need 2 tshirt design with name, i need a high speed 5 or more data entry operator for our offline project that is only filling the form of 44 fields, i need someone to design website -- 2, i need someone to design website 2, i need a phone number to customer service for zeki tablet 10.1

About the Employer:
( 0 reviews ) Ballwin, United States

Project ID: #22211069

Awarded to:

P0L

Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.

$25 USD in 1 day
(332 Reviews)
7.3

6 freelancers are bidding on average $34 for this job

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$100 USD in 2 days
(338 Reviews)
8.0
MimiFL

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

$15 USD in 1 day
(496 Reviews)
7.0
hkh581e5c8f1cb8a

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 More

$12 USD in 1 day
(12 Reviews)
3.8
$25 USD in 2 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0