I have columns of numbers, adding up to various amounts. I need to calculate the percentage each one of these numbers bears to the total of each column.
IE Column contains the numbers 3, 11, and 6. Total is
20. I therefore need to know the percentages that 3, 11 and 6 would be of 20.
Does anyone have any idea of what formula would be needed to extrapolate the required percentages? I hope its a fairly simple one, as I have a number of them to do on a monthly basis.
Sorry if this is simplistic, but I have exactly three days experience with Excel. Thank you.
|Check out our Excel Resources|
Here is one easy way:
=A1/SUM(A1:A10) Then format the cell as a percentage.
This will tell you the what percentage A1 is of the Total of A1:A10
OzGrid Business Applications
...you can copy it down a column adjacent to
your list of numbers and accurate results.
A1 3 =A1/SUM($A$1:$A$3)
A2 11 =A2/SUM($A$1:$A$3)
A3 6 =A3/SUM($A$1:$A$3)
A1 3 =A1/$A$4
A2 11 =A2/$A$4
A3 6 =A3/$A$4
then format the calculations as percentages.
The "$" creates an 'Absolute' reference that doesn't change as you copy the calculation