cumulative percentage

[nan_kumar]

how to calculate cumulative percentage in excel show with example

 

[kaushik03]

Hi nan_kumar,


Welcome to this forum.


I assume you have data from A1 to A9 as follows:


8

4

5

6

8

7

5

1

3


At B1 please write: =SUM(A$1:A1)/SUM($A$1:$A$9) and copy it down to get the cumulative percentage.


Hope this helps.


Regards,

Kaushik

 

[Hui]

Nan_Kumar


Firstly, Welcome to the Chandoo.org forums.


Cummulative % is simply a column next to your data with a formula like

=Sum($A$1:A1)/Sum($A$1:$A$100) in Column B1

Copy B1 down

This will show the Cummulative Percent for each cell in Column A in the adjacent cell in Column B


Typically at Chandoo.org we prefer you to post a sample file of your data: http://chandoo.org/forums/topic/posting-a-sample-workbook


Please also read the 3 sticky green posts at the top of: http://chandoo.org/forums/