Consolidating multiple functions and columns into a single column

So I'm trying to get this table into four columns. Category, Percent, Monthly Maximum, Total. The Total needs to be able to do all the math that Adjusted through Total does. I have gotten to the Ratio column, but then I run into a snag.

Just to break it down, Category, Percent, and monthly maximum are manual columns that I have to enter data into. The Adjusted column will display whether the Monthly Maximum or (Percent * Paycheck) is lower. In the Leftover column, the (Percent * paycheck) - Monthly Maximum is calculated if Monthly Maximum is exceeded. In the numerator column, a category will be 0% if it has exceeded the Monthly Maximum, otherwise, the Percent column value is carried over. Then the values of the Numerator column are added up giving the denominator (not a column). The ratio is calculated based on the Numerator column divided by the Denominator value (or the sum of the Numerator Column). In order to make this calculated part into a single column, I need to find a way to not use the Total row at the very bottom. I have tried using sumif and sumifs functions but I keep running into problems.

=IF([@[Monthly Maximum]]=0,[@Percent]*$B$1,[@[Monthly Maximum]])+IF([@[Monthly Maximum]]=0,($B$1*SUMPRODUCT([Percent]*([Monthly Maximum]>0))-$D$1)*[@Percent]/SUMPRODUCT([Percent]*([Monthly Maximum]=0)),)

So this is close to what I need. It appears that when the monthly maximums add up to larger than the paycheck, categories without maximums go negative. I would still like each category to have funds distributed evenly. This is great tho, and definitely a step in the right direction. I’m going to look over it a little more.

I've determined that the equation I needed was

{=(IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4)))+((IF([@[Monthly Maximum]]=0,[@Percent],IF(IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4))>=[@[Monthly Maximum]],0,[@Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0)))))}.

On top of this, I have noticed another problem. A total still has the potential of exceeding its maximum. When a paycheck is distributed and the portion of a category is under the max the leftovers can push the total over the maximum. For this, I created the following.

{=(IF([@[Monthly Maximum]]=0,((IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4)))+((IF([@[Monthly Maximum]]=0,[@Percent],IF(IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4))>=[@[Monthly Maximum]],0,[@Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0)))))),IF(((IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4)))+((IF([@[Monthly Maximum]]=0,[@Percent],IF(IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4))>=[@[Monthly Maximum]],0,[@Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0))))))>=[@[Monthly Maximum]],[@[Monthly Maximum]],((IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4)))+((IF([@[Monthly Maximum]]=0,[@Percent],IF(IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4))>=[@[Monthly Maximum]],0,[@Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0)))))))))+((IF([@[Monthly Maximum]]=0,[@Percent],IF(IF([@[Monthly Maximum]]=0,((IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4)))+((IF([@[Monthly Maximum]]=0,[@Percent],IF(IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4))>=[@[Monthly Maximum]],0,[@Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0)))))),IF(((IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4)))+((IF([@[Monthly Maximum]]=0,[@Percent],IF(IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4))>=[@[Monthly Maximum]],0,[@Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0))))))>=[@[Monthly Maximum]],[@[Monthly Maximum]],((IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4)))+((IF([@[Monthly Maximum]]=0,[@Percent],IF(IF([@[Monthly Maximum]]=0,[@Percent]*$C$4,IF([@Percent]*$C$4>=[@[Monthly Maximum]],[@[Monthly Maximum]],[@Percent]*$C$4))>=[@[Monthly Maximum]],0,[@Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0))))))))>=[@[Monthly Maximum]],0,[@Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>((IF([Monthly Maximum]=0,[Percent]*$C$4,IF([Percent]*$C$4>=[Monthly Maximum],[Monthly Maximum],[Percent]*$C$4)))+((IF([Monthly Maximum]=0,[Percent],IF(IF([Monthly Maximum]=0,[Percent]*$C$4,IF([Percent]*$C$4>=[Monthly Maximum],[Monthly Maximum],[Percent]*$C$4))>=[Monthly Maximum],0,[Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0))))))))+SUMPRODUCT([Percent]*([Monthly Maximum]=0))))*(SUMPRODUCT(((IF([Monthly Maximum]=0,[Percent]*$C$4,IF([Percent]*$C$4>=[Monthly Maximum],[Monthly Maximum],[Percent]*$C$4)))+((IF([Monthly Maximum]=0,[Percent],IF(IF([Monthly Maximum]=0,[Percent]*$C$4,IF([Percent]*$C$4>=[Monthly Maximum],[Monthly Maximum],[Percent]*$C$4))>=[Monthly Maximum],0,[Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0)))))-[Monthly Maximum])*((IF([Monthly Maximum]=0,[Percent]*$C$4,IF([Percent]*$C$4>=[Monthly Maximum],[Monthly Maximum],[Percent]*$C$4)))+((IF([Monthly Maximum]=0,[Percent],IF(IF([Monthly Maximum]=0,[Percent]*$C$4,IF([Percent]*$C$4>=[Monthly Maximum],[Monthly Maximum],[Percent]*$C$4))>=[Monthly Maximum],0,[Percent])))/(SUMPRODUCT([Percent]*([Monthly Maximum]>[Percent]*$C$4))+SUMPRODUCT([Percent]*([Monthly Maximum]=0)))*(SUMPRODUCT((([Percent]*$C$4)-[Monthly Maximum])*(([Percent]*$C$4>[Monthly Maximum])*([Monthly Maximum]>0)))))>[Monthly Maximum])*([Monthly Maximum]>0)))}

This equation essentially takes the leftovers and redistributes to the appropriate categories that have not exceed the maximums. I've determined that this kind of equation must be run a maximum of times that there are categories in the budget. Unfortunately, I have hit the character limit. Does anyone know an easier way to write this equation, or an easier way to complete this process?
Another quick thing to throw out there is, is there a way to run an equation as many times as the results of a count() funtion? Like count(category) would then run the equation for how many categories, ensuring that the leftovers were distributed evenly to all the categories are discribed?
Thanks for the help guys!

changed formulas in D1 and in column total new

It looks like what you created does most of it but when some categories have hit their max, it stops others that have not hit their max from receiving any funds from the leftovers. This leads to funds not distributed completely proportionately which I definitely need.

D1 =SUM(IF(_t[Monthly Maximum]>_t[Percent]*B1,,_t[Monthly Maximum])) as array f

That equation does not create the same results as the equation I posted earlier, though, when some categories maximums have been met and others have not. Compare the total new column to the total equation column. In sheet1, the paycheck exceeds what is needed to fulfill each categories' maximum so the total new (your equation) and the total equation (my equation) match up. However, as in sheet2, when the paycheck does not provide enough to fulfill the maximums, the total new column does not equal the total equation column. Your column does not distribute leftovers among categories that have yet to hit their maximum. My equation does do this. Can my equation be simplified any further without changing the results?
Thanks