Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12

Thread: cumulative percentage

  1. #1
    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. #2
    Join Date
    19th July 2004
    Location
    Tokyo, Japan
    Posts
    8,220
    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. #3
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313
    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)

    Cheers
    Andy


  4. #4
    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. #5
    Join Date
    11th February 2003
    Location
    Near the Land of OZ
    Posts
    1,591
    Which reference? Maybe add an absolute before the second C in Andy's formula.

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

    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt

    Old, slow, and confused - but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3.28.2008)

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

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    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. #8
    Join Date
    11th February 2003
    Location
    Near the Land of OZ
    Posts
    1,591
    Are you using R1C1 references in Excel? Check:

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

    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt

    Old, slow, and confused - but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3.28.2008)

  9. #9
    Join Date
    15th September 2004
    Posts
    105
    Hey Shades
    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. #10
    Join Date
    11th February 2003
    Location
    Near the Land of OZ
    Posts
    1,591
    Does the formula work in D2?

    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt

    Old, slow, and confused - but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3.28.2008)

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Count Of Cumulative Percentage Of Total
    By buzz in forum EXCEL HELP
    Replies: 10
    Last Post: February 21st, 2008, 02:53
  2. Percentage Of a Cumulative Target
    By Jins in forum EXCEL HELP
    Replies: 4
    Last Post: January 6th, 2008, 10:07
  3. Cumulative value
    By ashab02 in forum EXCEL HELP
    Replies: 17
    Last Post: September 3rd, 2006, 15:08
  4. Running Cumulative
    By richardcranney in forum EXCEL HELP
    Replies: 5
    Last Post: August 19th, 2006, 05:10
  5. Cumulative Sum
    By Timbo in forum EXCEL HELP
    Replies: 12
    Last Post: May 19th, 2005, 18:34

Bookmarks

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