Running totals for Balance of a split transaction that is remaining to be allocated to different accounts

[Wikkey]

I used the formulas from a previous answered question "balance of a split transaction that is remaining to allocated", but I have a few different questions. Because I post to different accounts on the sheet. I want to leave the running balance formulas as is but I need to add to the formula if E column has a "split" in it, it doesnt add the value in J&K column to the running totals. If that makes sense.
Any help with this is gratly appreaciated.

Our Budget & s.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
4	Account	Date	Num	Payee	Memo	Main Category	Category	Clr	Remaining AMT	PAYMENT	DEPOSIT	Account Balance	Cleared Balance	BALANCE
5	Checking RBC	2/01/22		[Beginning Balance]			[Beginning Balance]	R			683.21	683.21	683.21	683.21
6	Savings RBC	2/01/22		[Beginning Balance]			[Beginning Balance]	R			8,000.63	8,000.63	8,000.63	8,683.84
7	Savings Tangerine	2/01/22		[Beginning Balance]			[Beginning Balance]	R			56,052.72	56,052.72	56,052.72	64,736.56
8	Master Card	2/01/22		[Beginning Balance]			[Beginning Balance]	R		163.89		(163.89)	(163.89)	64,572.67
9	Visa RBC	2/01/22		[Beginning Balance]			[Beginning Balance]	R			-	-	-	64,572.67
10	Visa Old	2/01/22		[Beginning Balance]			[Beginning Balance]	R			-	-	-	64,572.67
11	Bev's IG RRSP	2/01/22		[Beginning Balance]			[Beginning Balance]	R				-	-	64,572.67
12	Bev's IG TFSA	2/01/22		[Beginning Balance]			[Beginning Balance]	R				-	-	64,572.67
13	Dar's IG RRSP	2/01/22		[Beginning Balance]			[Beginning Balance]	R				-	-	64,572.67
14	Dar's IG TFSA	2/01/22		[Beginning Balance]			[Beginning Balance]	R				-	-	64,572.67
15	IG Joint	2/01/22		[Beginning Balance]			[Beginning Balance]	R				-	-	64,572.67
16	Great West Life	2/01/22		[Beginning Balance]			[Beginning Balance]	R				-	-	64,572.67
17	Checking RBC	2/01/22		Canada Life		INCOME	Refunds/Reimbursements	c			136.48	819.69	819.69	64,709.15
18	Savings Tangerine	2/01/22		Interest Paid		INCOME	Interest Income	c			3.97	56,056.69	56,056.69	64,713.12
19	Savings Tangerine	2/01/22		Bonus Interest		INCOME	Interest Income	c			70.44	56,127.13	56,127.13	64,783.56
20	Savings RBC	2/01/22		Interest Paid		INCOME	Interest Income	c			0.31	8,000.94	8,000.94	64,783.87
21	Checking RBC	2/02/22	TXFR	[To Savings}		TRANSPORTATION	Boat Insurance	c		42.25		777.44	777.44	64,741.62
22	Checking RBC	2/02/22	TXFR	[To Savings}		TRANSPORTATION	Auto Insurance	c		15.25		762.19	762.19	64,726.37
23	Checking RBC	2/02/22	TXFR	[To Savings}		HOUSING	House Insurance	c		35.50		726.69	726.69	64,690.87
24	Checking RBC	2/02/22	TXFR	[To Savings}		HOUSING	Property Taxes	c		61.50		665.19	665.19	64,629.37
25	Savings RBC	2/02/22	TXFR	[From Checking]			[Transfer]	c			154.50	8,155.44	8,155.44	64,783.87
26	Checking RBC	2/02/22		Canada Life Disability		INCOME	Canada Life Disability	c			1,521.00	2,186.19	2,186.19	66,304.87
27	Checking RBC	2/02/22		Canada Life Disability		DEBT	Income Tax	c		356.09		1,830.10	1,830.10	65,948.78
28	Checking RBC	2/02/22	4833	Amanda Bartok		FOOD	Groceries	c		77.97		1,752.13	1,752.13	65,870.81
29	Master Card	2/02/22		A&W	Split…	DEBT	Split (Mulitple Categories)…		-	33.30		(197.19)	(163.89)	65,837.51
30	Master Card	2/03/22			split	FOOD	Take Out			30.00		(227.19)	(163.89)	65,807.51
31	Master Card	2/04/22			split	DEBT	Sales Tax			3.30		(230.49)	(163.89)	65,804.21
Transactions

Cell Formulas
Range	Formula
L5:L31	L5	=SUMIFS(K$4:OFFSET(K5,0,0),A$4:OFFSET(A5,0,0),"="&A5)-SUMIFS(J$4:OFFSET(J5,0,0),A$4:OFFSET(A5,0,0),"="&A5)
M5:M31	M5	=SUMIFS(K$4:OFFSET(K5,0,0),A$4:OFFSET(A5,0,0),"="&A5,H$4:OFFSET(H5,0,0),"<>")-SUMIFS(J$4:OFFSET(J5,0,0),A$4:OFFSET(A5,0,0),"="&A5,H$4:OFFSET(H5,0,0),"<>")
N5:N31	N5	=SUM(OFFSET(N5,-1,0),K5,-J5)
E5:E31	E5	=IF(G3="Split (Mulitple Categories)…","split",IF(G4="Split (Mulitple Categories)…","split",IF(G5="Split (Mulitple Categories)…","Split…","")))
I5:I31	I5	=IF(E5="Split…",2*SUM(J5:K5)-SUM(J5:INDEX(K6:K$74,MATCH(TRUE,INDEX(G6:G$74<>"split",0),0)-1)),"")

Named Ranges
Name	Refers To	Cells
Print_Titles	=Transactions!$4:$4	L5:M31

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
N5:N178	Cell Value	<0	text	YES
A85:A110,A76:A82,A116:A120,A125:A135,A138:A148,A162:A178,A150:A157,A5:A65	Expression	=AND(ISERROR(MATCH(A5,accounts,0)),NOT(ISBLANK(A5)))	text	YES
G85:G106,G76:G82,G109:G110,G116:G120,G5:G65,G125:G135,G138:G148,G162:G178,G150:G157	Expression	=AND(NOT(ISBLANK(G5)),ISERROR(MATCH(G5,categories,0)))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
A5:A31	List	=accounts
F5:F178	List	=MainCat
G5:G16	List	=categories
H5:H178	List	x,c,R
G17:G178	List	=OFFSET($U$6,1,MATCH($F17,$U$6:$AF$6,0)-1,COUNTA(OFFSET($U$6,1,MATCH($F17,$U$6:$AF$6,0)-1,15)),1)

 

[Wikkey]

=SUMIFS(K$4:OFFSET(K29,0,0),A$4:OFFSET(A29,0,0),"="&A29)+IF(E29="split",L28+J29-J29,-SUMIFS(J$4:OFFSET(J29,0,0),A$4:OFFSET(A29,0,0),"="&A29))
I found a partial answer to one of my problems, the new formula I added is above in blue. I don't know if that is an efficient way of doing it but it works. Rows 30 and 31 will give the same amount as row 29. I'm wondering if there is a better formula for column l to n, if column E = split I don't want to add the amount column K.
Still not sure I am giving the right info for what I'm trying to accomplish.
Thanks for any assistance.