sedang Berlangsung

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

Keahlian: Excel, Pemrosesan Data, Entri Data, Matematika, Statistika

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 0 ulasan ) Ballwin, United States

ID Proyek: #22211069

Diberikan kepada:

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 dalam 1 hari
(332 Ulasan)
7.3

6 freelancer menawar dengan rata-rata $34 untuk pekerjaan ini

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 Lebih banyak

$100 USD dalam 2 hari
(338 Ulasan)
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 dalam 1 hari
(496 Ulasan)
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 Lebih banyak

$12 USD dalam 1 hari
(12 Ulasan)
3.8
$25 USD dalam 2 hari
(0 Ulasan)
0.0
$25 USD dalam 1 hari
(0 Ulasan)
0.0