+ Reply to Thread
Results 1 to 7 of 7

Compute total score based on student number

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2003
    Posts
    5

    Compute total score based on student number

    Hi guys/gals,

    I want to compute the [Total] and [Number of Attempts] each student received based on three separate tests.

    Here is a sample:

    [Student Number] [Score]
    1299375 2
    1299375 1
    1299375 1
    1300508 1
    1300508 1
    1300607 0
    1300904 0

    I would like the output to look like this:

    [Student Number] [Total] [Attempts]
    1299375 4 3
    1300508 2 2
    1300607 0 1
    1300904 0 1


    Have also attached full file I want to manipulate.

    Thanks for the help!
    Attached Files Attached Files
    Last edited by sinth; 01-28-2012 at 02:56 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,142

    Re: Compute total score based on student number

    Amended file attached, with three formulae giving what you want.

    Hope this helps.

    Pete
    Attached Files Attached Files
    Last edited by Pete_UK; 01-27-2012 at 06:13 AM. Reason: added file

  3. #3
    Registered User
    Join Date
    01-27-2012
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Compute total score based on student number

    Thanks Pete.

    I would have never solved it myself.

    Looking at the function now so that I can fully understand it.

    Edit: I can't work out how to mark this thread as [solved].

    Is this done by admins?
    Last edited by sinth; 01-27-2012 at 07:36 AM. Reason: Solved

  4. #4
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Compute total score based on student number

    Sinth: Read my signature to mark it as SOLVED
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved

  5. #5
    Registered User
    Join Date
    01-27-2012
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Compute total score based on student number

    Thanks kelshaer.

    Actually, I have one more question.

    Why am I unable to modify the formula.

    When I simply click on the formula and then click elsewhere, it returns the result "n/a"

    It appears that the brackets go missing and then it stuffs up. The brackets are { and }

    I want to change the range on the formula but can't do this!

    It's something to do with the countif function but I can't work out exactly what!

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,142

    Re: Compute total score based on student number

    Quote Originally Posted by sinth View Post
    Thanks kelshaer.

    Actually, I have one more question.

    Why am I unable to modify the formula.

    When I simply click on the formula and then click elsewhere, it returns the result "n/a"

    It appears that the brackets go missing and then it stuffs up. The brackets are { and }

    I want to change the range on the formula but can't do this!

    It's something to do with the countif function but I can't work out exactly what!
    Hi sinth,

    it's because the first formula is an array formula. When you type it in (or edit it in your case) you must commit it using the key combination of Ctrl-Shift-Enter rather than the usual <enter>. If you do this correctly then Excel will wrap curly braces { } around the formula, but you must not type these yourself. You can then copy the formula down the column in your usual way.

    Hope this helps.

    Pete

  7. #7
    Registered User
    Join Date
    01-27-2012
    Location
    Prague, Czech Republic
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Compute total score based on student number

    Yes, it does help.

    I learnt that the hard way, heh I was trying to put the brackets in myself!

    Thanks very much again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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