I have arrays arranged down a column, one array for each product formula. I
have the data in Pounds per Batch with the Total Pounds at the bottom. I
want to convert the elements of the array (the ones above the total) to
percentages. I obviously can take element #1 * 100 / Sum but the problem is
some arrays have two elements, some have 5, some have 8...

Example:

What I have:
Element 1 300
Element 2 200
TOTAL 500

(next array)
Element 1 900
Element 2 1800
Element 3 450
Element 4 1850
TOTAL 5000

What I'd like to have Excel generate:
Element 1 300 60.00
Element 2 200 40.00
TOTAL 500 100.00 (this would be optional)

(next array)
Element 1 900 18.00
Element 2 1800 36.00
Element 3 450 9.00
Element 4 1850 37.00
TOTAL 5000 100.00 (once again, optional for the
total)

Thanks