Are we to assume you want the percent of total weight?

Then assuming the table is in A2 - B10

=b2/Sum(B$2:B$10)and copy down to the bottom

$ keeps the 2 and 10 frm changing as you copy down.

"Ruko" wrote:

I have a recipe that contains a column of 24 different items with their
weights. I want to calculate the percentages of each of the 24 items and
place the result in the next column. How do I do it? Example: Celery 5.0
Carrots 4.0
Oatmeal 10.0
Total 19.0

In the column next to the weights I want percent.

Thanks

ruko

--
Ruko