Thilly Excel question

Discussion in 'OT Technology' started by ices, Dec 26, 2005.

  1. ices

    ices New Member

    Joined:
    Jan 19, 2005
    Messages:
    680
    Likes Received:
    0
    If I have a list of 5 random names, how do I add up numbers that are connected to a specific person? IE...

    ----------Money Won from a Poker Game, Minutes Playing a Poker Game
    Bob
    Ryan
    John
    Lisa
    Michelle
    Bob
    Lisa
    Michelle
    John
    Ryan
    ...
    ..
    .

    How do I take the sum of the total time Bob played poker? I know I can do a =SUM command, and click all of the corresponding cells, but is there a way that I can make a box dedicated to Bob's total time that automatically compounds his total whenever I input his information into a new cell?
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    =SUMIF(A:A,"bob",C:C)
     

Share This Page