basic question - how to calculate a cumulative percentage?

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

=SUM($BE$1:$B1)

--
HTH

Bob

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

"Prospect" <Prospect@discussions.microsoft.com> wrote in message
news:0FEECA58-B552-42D4-B0D2-E7000AC68FAC@microsoft.com...
>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.
> --
> David

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

"Prospect" <Prospect@discussions.microsoft.com> wrote in message
news:0FEECA58-B552-42D4-B0D2-E7000AC68FAC@microsoft.com...
>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.
> --
> David

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)

"Bob Phillips" <bob.ngs@somewhere.com> wrote in message
news:%23xvTmJrdHHA.4340@TK2MSFTNGP06.phx.gbl...
> =SUM($BE$1:$B1)
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my
> addy)
>
> "Prospect" <Prospect@discussions.microsoft.com> wrote in message
> news:0FEECA58-B552-42D4-B0D2-E7000AC68FAC@microsoft.com...
>>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.
>> --
>> David
>
>
>