Screen Shot 2018-12-19 at 12.55.39 PM.png

I attached a screen shot to hopefully clarify this. I have 75 items in my garden and I want to enter the top 10 items that take up the most space. I want the remaining 65 items to auto calculate and auto adjust the "Feet Planted" column and the % amount in the "Garden Space" column. And everything in the "Garden Space" column should total 100%.

I am currently running the formula using 3326 as my total area.

Thanks!!