Posted by FW on March 27, 2001 1:26 PM
I'm an Excel rookie who has been thrown into this with no training or manual. I'm trying to calculate some percentages. I've had a look at both Percentile and Percentrank, and can't get them to do what I need.
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.