Basic question - how to calculate a cumulative percentage

G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

basic question - how to calculate a cumulative percentage? 3
Calculating cumulative percentage 4
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pareto's Law and ABCD ranking of items 2
How do I calculate percentages in a pivot table? 1
return value 2
If statement with multiple criteria and multiple results 3
alternative formula for VLOOKUP since it stops with the 1st value itself 2

Top