Calculating cumulative percentage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Prospect - 04 Apr 2007 11:46 GMT

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.

Signature

David

Reply to this Message

Max - 04 Apr 2007 12:10 GMT

One way ..
In C1: =SUM($B$1:B1)
Copy down

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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
[quoted text clipped - 8 lines]
>
> Thanks for your help.

Reply to this Message

Prospect - 04 Apr 2007 12:22 GMT

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

Signature

David

> One way ..
> In C1: =SUM($B$1:B1)
[quoted text clipped - 11 lines]
> >
> > Thanks for your help.

Reply to this Message

Mike - 04 Apr 2007 12:30 GMT

In B1 and dragged down

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

Mike

> oh, of course!
> Now I'm curious...what if I hadn't already calculated each percentage and
[quoted text clipped - 15 lines]
> > >
> > > Thanks for your help.

Reply to this Message

Max - 05 Apr 2007 04:12 GMT

In B1:
=SUM(A$1:A1)/SUM(A:A)
Format B1 as percentage, copy down.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message