Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

1. Senior Member
Join Date
15th September 2004
Posts
105

## cumulative percentage

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

Excel Video Tutorials / Excel Dashboards Reports

2. Excel Samurai
Join Date
19th July 2004
Location
Tokyo, Japan
Posts
9,423
Hi,

in cell D2

=SUM(C\$2:C2)/SUM(\$C\$2:\$C\$20)

then copy down

hope it helps

jindon

Excel Video Tutorials / Excel Dashboards Reports

3. Hi,

Try this formula in D2 and then drag down.
Notice the use of relative and absolute (\$) references.

D2: =SUM(\$C\$2:C2)/SUM(\$C\$2:\$C\$20)

4. Senior Member
Join Date
15th September 2004
Posts
105
Hi Andy and Jindon

It is throwing me errors for the absolute ref:

Excel Video Tutorials / Excel Dashboards Reports

5. Resident Old Codger
Join Date
11th February 2003
Location
Near the Land of OZ
Posts
1,563
Which reference? Maybe add an absolute before the second C in Andy's formula.

D2: =SUM(\$C\$2:\$C2)/SUM(\$C\$2:\$C\$20)

6. Senior Member
Join Date
15th September 2004
Posts
105
no shades the first \$C\$2 it shows the error

Excel Video Tutorials / Excel Dashboards Reports

7. Senior Member
Join Date
15th September 2004
Posts
105
when i write this formula n press enter for in the first cell in R2C7 is it cos of this is there a change in the formula
sometimes my excel sheets shows A,B and C for columns.. sometimes it give numbers
do i hav to change the forumla

Excel Video Tutorials / Excel Dashboards Reports

8. Resident Old Codger
Join Date
11th February 2003
Location
Near the Land of OZ
Posts
1,563
Are you using R1C1 references in Excel? Check:

Tools > Options > General (tab). In upper left corner, be sure R1C1 is UNchecked.

9. Senior Member
Join Date
15th September 2004
Posts
105
Thanks So much but i dont know what is that i do when i drag the formulas is nto gettin into the consecutive rows
y is that

Excel Video Tutorials / Excel Dashboards Reports

10. Resident Old Codger
Join Date
11th February 2003
Location
Near the Land of OZ
Posts
1,563
Does the formula work in D2?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno