Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Excel 2003/2007

name, count
a, 3
b, 4
c, 9
...

Say I have data like this, is there a built-in function that can automatically count percentage for each row? (ie. a = (3/(3+4+9)) = 18.75%). Also the data will be added continuously. Can I know solutions for both Excel 2003 & 2007. Thanks.

share|improve this question
up vote 2 down vote accepted

Excel Lists will help you here.

  • Convert your range to a List and add a Totals Row (sum)
  • Insert an extra column to the list called Percentages and define the calulation for the first row ( = this row's count / the cell containing the total)
  • To add new rows, drag the list handle (bottom right) and add new data.

These instructions apply to Excel 2007 and 2010. Excel 2003 also supports Lists but without as much functionality as the later versions, if I recall correctly.

share|improve this answer

you could also just make a total at the bottom, and calculate this for each row (just fill down): =[current row's calculated number]/[total]. just replace those two values and for the total field make it look like this $B$2 (or $G$5)

this is much simpler than making a list, although lists still work nicer.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .