basic question - how to calculate a cumulative percentage?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of data with percentages of the total in the next column. I
now want to add a third column that shows the cumulative percentage of the
total. Something like:
1 2 3
A 10 10% 10%
B 20 20% 30%
C 30 30% 60%
D 40 40% 100%

What formula should I use to calculate the values for the third column?

Thanks for your help.
 
=SUM($BE$1:$B1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
If the numbers you are trying to accumulate are in column C, starting at C2,
try =SUM(C$2:C2) and copy down.
 
Sorry, typo, that should be

=SUM($B$1:$B1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top