How to make a running tally based off other cells' color (or cell values)

[respawn]

I have a transaction worksheet I use to track some personal financials. I just want to have a running tally of the buys vs the sells. Something that will update on the fly when new data is added to the appropriate columns.
I read that I cant attach my sample data (as a worksheet) but am going to try the Mr.Excel HTML maker and paste below.

Basically, I want all the totals (column H) for sells (which are red) to be totaled in L1. And all the totals (column H) that are Purchases (which are green) in N1. The Xfers (blue) will be ignored.

I already have the formula in each cell of column H:
=IF(ISNUMBER(SEARCH("Sell",J#)), F#-G#, F#+G#)

Where # is incrementally the row number. And this just simply determines if the total should be subtotal - fee (for a sale) or subtotal + fee (for a buy).

I tried to do a modification of the above to include a range, but the fact that the color/transaction type is variable was throwing me off. Any help would be appreciated. Let me know if any clarifications are needed.

Happy New Year!

Excel 2010

	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Type	Ref Code	Amount	Price	Subtotal	Fees	Total	Date	transaction	Buy Amt	0	Sell Amt	0
2	A	1234	8000000	0.00000007	0.56	0.00112	0.56112	12/25/2017	Purchase
3	C	1235	151000	0.00002000	3.02	0.00604	3.02604	12/25/2017	Purchase
4	A	1236	8000000	0.00000014	1.12	0.00224	1.11776	12/26/2017	Sell
5	B	1237	68490580.86	0.00000001	0.6849058	0.00136981	0.68627561	12/26/2017	Purchase
6	A	1238	4800000	0.00000009	0.432	0.000864	0.432864	12/26/2017	Purchase
7	A	1239	4800000	0.00000014	0.672	0.001344	0.670656	12/26/2017	Sell
8	B	1240	3.94	740	2915.6	0	2915.6	12/27/2017	Xfer
9	A	1241	46141600	0.00000010	4.61416	0.00922832	4.62338832	12/27/2017	Purchase
10	B	1242	10	0.01653000	0.1653	0	2000	12/30/2017	Purchase
11	C	1243	0.1653	12580	2000	0	2000	12/30/2017	Xfer
12	C	1244	3.0162056	0.05469457	0.16497006	0.00032994	0.1653	12/30/2017	Purchase
13	C	1245	40585	0.00001400	0.56819	0.00113638	0.56932638	12/30/2017	Purchase
14	D	1246	20000	0.00004810	0.962	0.001924	0.963924	12/30/2017	Purchase
15	D	1247	20000	0.00005400	1.07999999	0.00215999	1.07784	12/30/2017	Sell
16	A	1248	19265232.8	0.0000001	1.92652328	0.00385304	1.92267024	12/31/2017	Sell
17	A	1249	3534486.93	0.0000001	0.35344869	0.00070689	0.3527418	12/31/2017	Sell

<tbody>
</tbody>

X

In the example above, the yellow cell L1 would be 2011.028238 and N1 would be 5.14166804.​

 

[JumpingCrab]

wouldn't this just be as simple as this?:

Cell L1 : =SUMIF(J2:J17,"Purchase",H2:H17)
Cell N1: =SUMIF(J2:J17,"Sell",H2:H17)

Or am I missing something?

 

[respawn]

wouldn't this just be as simple as this?:

Cell L1 : =SUMIF(J2:J17,"Purchase",H2:H17)
Cell N1: =SUMIF(J2:J17,"Sell",H2:H17)

Or am I missing something?

Nope, that's perfect!! I thought it would be something "simple" just couldn't get it working. SUMIF, have to remember to use that more. Thanks a million!! =)

 

[JumpingCrab]

Glad to be of help