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

One way ..
In C1: =SUM($B$1:B1)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Prospect" wrote:
> 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

oh, of course!
Now I'm curious...what if I hadn't already calculated each percentage and
only wanted the cumulative figure?
--
David


"Max" wrote:

> One way ..
> In C1: =SUM($B$1:B1)
> Copy down
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Prospect" wrote:
> > 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

In B1 and dragged down

=(A1/(SUM(A$1:A$4)/100))

Mike

"Prospect" wrote:

> oh, of course!
> Now I'm curious...what if I hadn't already calculated each percentage and
> only wanted the cumulative figure?
> --
> David
>
>
> "Max" wrote:
>
> > One way ..
> > In C1: =SUM($B$1:B1)
> > Copy down
> > --
> > Max
> > Singapore
> > http://savefile.com/projects/236895
> > xdemechanik
> > ---
> > "Prospect" wrote:
> > > 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

In B1:
=SUM(A$1:A1)/SUM(A:A)
Format B1 as percentage, copy down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Prospect" wrote:
> oh, of course!
> Now I'm curious...what if I hadn't already calculated each percentage and
> only wanted the cumulative figure?
> --
> David