Home› All Encompassing Trip

another excel question

PearlJamaholicPearlJamaholic Posts: 2,018
edited January 2008 in All Encompassing Trip
i have a list of years and i need excel to give me totals for each year and i cant remember how to do this. i dont like when i forget this easy stuff.
http://db.etree.org/PearlJamaholic
Post edited by Unknown User on

Comments

  • Heineken HelenHeineken Helen Posts: 18,095
    hmm... isn't it =sum (then add the column you wanna start with) : (then add the column you wanna end with?) :confused:
    The Astoria??? Orgazmic!
    Verona??? it's all surmountable
    Dublin 23.08.06 "The beauty of Ireland, right there!"
    Wembley? We all believe!
    Copenhagen?? your light made us stars
    Chicago 07? And love
    What a different life
    Had I not found this love with you
  • lalalalaaaaaaaalalalalaaaaaaaa Posts: 2,445
    Hit F1
  • RolandTD20KdrummerRolandTD20Kdrummer Posts: 13,066
    Highlight the data then look for the sum button Σ on the toolbar...
    and click it...done.

    or type =sum(cell#:cell#) in the formula window.

    or just hit F1 and type in sum.
    Progress is not made by everyone joining some new fad,
    and reveling in it's loyalty. It's made by forming coalitions
    over specific principles, goals, and policies.

    http://i36.tinypic.com/66j31x.jpg

    (\__/)
    ( o.O)
    (")_(")
  • PearlJamaholicPearlJamaholic Posts: 2,018
    i guess i should have been clearer. i want how many of each year i have. like 4 1994 and 11 1995, but so it keeps a running total. so on another sheet i can just have the year with the total underneath. i know ill need to have the whole column highlighted but i dont remember the function.
    http://db.etree.org/PearlJamaholic
  • polarispolaris Posts: 3,527
    sumif is the function

    sumif (your year cells, the year you want, the cells with the value you want to add)
  • chinobaezachinobaeza Posts: 2,489
    two words: dynamic tables
  • nfanelnfanel Posts: 2,558
    sounds like you want a pivot table. go to data --> pivot table and then the wizard will guide you through it.when you get to the layout, you'll want to put the year in the rows and whatever you're trying to sum in the data section....
  • markymark550markymark550 Posts: 5,154
    so you are counting the number of times a year appears in your data?

    in that case, use the COUNTIF function: COUNTIF(range, criteria)

    ex) COUNTIF(A1:A20, "1994")
  • PJSerfPJSerf Posts: 637
    nfanel wrote:
    sounds like you want a pivot table. go to data --> pivot table and then the wizard will guide you through it.

    Pivot Tables are the greatest thing since sliced bread.
    "If you love someone, set them free... if someone loves you, don't fuck up" - EV
  • nfanelnfanel Posts: 2,558
    PJSerf wrote:
    Pivot Tables are the greatest thing since sliced bread.
    i do love them. :D
  • PearlJamaholicPearlJamaholic Posts: 2,018
    markymark550 wrote:
    so you are counting the number of times a year appears in your data?

    in that case, use the COUNTIF function: COUNTIF(range, criteria)

    ex) COUNTIF(A1:A20, "1994")
    Thats the one!!!! thanks. i cant believe i forgot. as soon as i saw countif it came back. i feel so stupid. oh well im use to that.
    http://db.etree.org/PearlJamaholic
  • markymark550markymark550 Posts: 5,154
    PearlJamaholic wrote:
    Thats the one!!!! thanks. i cant believe i forgot. as soon as i saw countif it came back. i feel so stupid. oh well im use to that.
    no problem....at first I thought it was the sumif that was mentioned, but then I re-read your clarification and knew that sumif would return some screwy numbers for that, so logically, it had to be countif

    just glad I could help out....
Sign In or Register to comment.