Using comma separated values in a single cell

Hi, welcome to the forum

Im not sure if that file is protected or what (I dont use google docs much), but I am unable to type anything into it.

Besides, please upload your workbook to the forum, not all members are able - or willing - to open files like that.

THis will kinda do what you want, but you need to enter the values into the formula manually...

	G	H	I	J
2	1	3		[BGCOLOR=#FFFFFF]6[/BGCOLOR]
3	2	3
4	3	4
5	4	5
6	5	6
7	6	1

J2=SUM(SUMIF(H2:H10,{3,4},G2:G10))

I don't know how Google's spreadsheet works but a formula like this might be what you are looking for using the cell references in your displayed worksheet.

Formula:

=G6-SUMIFS($G$3:G5,$D$3:D5,"goog",$C$3:C5,"Buy")

Wasn't exactly sure how to post a table, but here is an attempt at a table:

B	C	D	E	F	G	H	I	J
Date	Trans Type	Symbol	Shares	Price	Total	TransID	Blocks Sold	Profit & Loss
1/5/15	buy	goog	100	500	50000	3
1/6/15	buy	goog	100	500	50000	4
1/10/15	dividend	goog	5	505	2525	5
1/14/15	sell	goog	205	520	106600	6	3,4,5

Basically, I need to know how to read in the values of 3,4,5 in I6 to calculate my P&L. This is similar to for loops (for iin $variable, do) Bash Scripting (not sure if there are any Linux user on this forum).

If you are just wanting to identify the rows as indicated in I6 This formula entered in I3 (assuming data starting in row 3) and filled down will put an X in where there is a match.

Formula:

=IF(SEARCH(H3,$I$6)>0,"x","")

This will enter the profit/loss in column J

Formula:

=IF(AND(C3="buy",I3="x"),($F$6-F3)*E3,IF(AND(C3="dividend",I3="X"),G3,""))

As far as the profit and loss calculation is concerned, I think that I already gave that to you in my previous message. If you are wanting to calculate that for each row. This will work for each row except for Dividends where you will want to add the total amount.

Thanks for the input newdoverman (&FDibbins). Your first post does work, but will not fulfill all the possible scenarios of my stock transactions. BUT, I think your post second postgot the wheels turning. Since I have 100's of stock transactions per year I need to have uniqueness to each transaction. I can reverse my current spreadsheet logic to assign transID's to only sells and then associate those transID's with the buys and divy's. Awesome, thanks for y'alls help with this problem.
Joe

I'm glad to have helped. Thanks for the feedback.