Forum Discussion
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
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.
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.
- Grazie mille e buona serata