Hi

How can i calculate in Excel ?

I have a row a from C2: C20 that has datas

8

4

5

6

0

7

0

0

0 and so on

I want to first sum them up n get a total say it is 30

n then i need to calculate the cumulative percentage like

D2 is 8/30

D3 is (8+4)/30

D4 is (8+4+5)/30

and so on...

Can someone help me with a formula in Excel

thanks

jamap

How can i calculate in Excel ?

I have a row a from C2: C20 that has datas

8

4

5

6

0

7

0

0

0 and so on

I want to first sum them up n get a total say it is 30

n then i need to calculate the cumulative percentage like

D2 is 8/30

D3 is (8+4)/30

D4 is (8+4+5)/30

and so on...

Can someone help me with a formula in Excel

thanks

jamap

## Comment