Calculate Percent in a Column
 

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

Calculate Percent in a Column
 

Assuming weights in column B and total in B4

=B1/$B$4

drag down and format as %

Mike

"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

Calculate Percent in a Column
 

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

Calculate Percent in a Column
 

Oops.. I didn't notice there was a total field. My bad...

"Mike H" wrote:

Assuming weights in column B and total in B4

=B1/$B$4

drag down and format as %

Mike

"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