maybe a quick IF question

[db49ers]

Column A: employee
Column C: title
H2:K6:
Server 18.0% 5 $2,923.35
Server B 18.0% 2 $487.23
Server Assistant 2.0% 3 $324.82
Bartender 3.0% 0 $-
Runner F&B 2.0% 2 $285.00
D27 formula:
=IF(A27="",0,(IF(C27=$H$2,($K$2-$K$3-$K$4-$K$5-$K$6-$K$7-$K$8)/COUNTIF($C$27:$C$52,$H$2),0)+(IF(C27=$H$3,$K$3/$J$3,0)+(IF(C27=$H$4,$K$4/$J$4,0)+(IF(C27=$H$5,$K$5/$J$5,0)+(IF(C27=$H$6,$K$6/$J$6,0)+(IF(C27=$H$7,$K$7/$J$7,0)+(IF(C27=$H$8,$K$8/$J$8,0)))))))))
Works great but I need K2 and K3 to both end up with what is left after paying out if anything matches H4 to H6.

 

[db49ers]

Another thing that is tough is in the case listed above I need the total in K2 to be divided up between H2 and H3. However, 5 in J2 plus and only 1 for J3, for 6 parts total. No matter what is in J3, it will be the total of J2 plus J3. K3 formula is:
=IF($J$3=0,0,(K2/SUM(J2+1)))