+ Reply to Thread
Results 1 to 2 of 2

how to sum(group) a large database

Hybrid View

  1. #1
    Registered User
    Join Date
    12-24-2009
    Location
    Germany,Munich
    MS-Off Ver
    Excel 2003
    Posts
    1

    how to sum(group) a large database

    well its a little bit stupid question :P

    well i made a large database, questioning people,
    for a work(university)

    i will use an excample (i cannot explain it perfectly)


    i want to group numbers (?)
    i aksed people about their age and and the age of their parntners

    lets asume i asked 5 people
    1. 34 and 30(partner)
    2. 42 and 35
    3. 41 and 31
    4. 42 and 35
    5. 29 and 35

    well i want to make a sum of how many people are 34,42,41,29
    in this excample
    42,twice
    41, one
    29,one
    34,one

    and a sum of the age of their partner and posible cominations (themselves-partner)
    in this excample
    35, three
    31, one
    30, one

    most recent comination is 42-35

    well i asked 200 people thats the problem... and i wanna make it on excel
    and i dont have any idea of excel

    i hope you can help me out
    thanx

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: how to sum(group) a large database

    Hi Sparxx,

    Welcome to the forum!

    The COUNTIF function will help you with that problem.

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

+ 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