 # Calcolo percentuale riga sul totale colonna

Buingiorno gentilmente qual'è la formula per calcolare la percentuale di ogni riga sul totale della colonna di una tabella excel . Grazie
4 Replies

# Re: Calcolo percentuale riga sul totale colonna

Could you attach a sample workbook and indicate what you want there?

# Re: Calcolo percentuale riga sul totale colonna

For work I decoded all the recipes in a word table, below for example, I would need THE FORMULA or know how to calculate the percentage of each row of the raw material, the last column on the right of the total of the recipe. thank you so much.

# Re: Calcolo percentuale riga sul totale colonna

You don't display the row numbers and column letters, so the following is just an example.

Let's say the Ric. Base data are in E4:E8, with the total in E9, and the percentages should be in I4:I8.

Enter the following formula in I4:

=100*E4/\$E\$8

Fill down to I8.

# Re: Calcolo percentuale riga sul totale colonna

Grazie mille e buona serata