basic question - how to calculate a cumulative percentage?

[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.

 

[Bob Phillips]

=SUM($BE$1:$B1)

--
HTH

Bob

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

 

[David Biddulph]

If the numbers you are trying to accumulate are in column C, starting at C2,
try =SUM(C$2:C2) and copy down.

 

[Bob Phillips]

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)