| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculating cumulative percentage
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculating cumulative percentage
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculating cumulative percentage
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculating cumulative percentage
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Basic question - how to calculate a cumulative percentage | Excel Discussion (Misc queries) | |||
| Calculating Percentage | Excel Worksheet Functions | |||
| Calculating a Percentage | Excel Worksheet Functions | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Calculating Percentage | Excel Worksheet Functions | |||
Hybrid Mode
