+ Reply to Thread
Results 1 to 2 of 2

Cumulative frequency formula???

  1. #1
    Registered User
    Join Date
    07-18-2008
    Location
    Newcastle
    Posts
    4

    Exclamation Cumulative frequency formula???

    Im trying to show:

    Duration Name cumulativeDuration
    3 Kev 3
    2 Kev 5
    4 Phil 4
    1 Phil 5
    2 Phil 7
    3 Jack 3
    2 Ross 2
    4 Ross 6
    5 Ross 11
    2 Ross 13

    Basically I want a formula (or macro) to get a cumulative amount based on the name given. If you have any suggestions, please help.

    Thanks, Kev

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    In C2 and down:

    =SUMIF($B$2:B2,B2,$A$2:A2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1