+ Reply to Thread
Results 1 to 4 of 4

How to add points when the answer is correct?

Hybrid View

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    How to add points when the answer is correct?

    My apologies if this question has already been asked/answered and thanks in advance for any help.

    I've set up a spreadsheet for the 2012-2013 college football bowl season. I've had excel randomly add a point value(1-4 and 5 for championship game) to each game. I've also created a drop down list for the participant to pick who they think is going to win and a list for the moderator to add the winner.

    Q: Is there a way to have excel count the point value if the participant correctly chooses the winner?

    I've attached a copy of what I currently have, thanks.
    Attached Files Attached Files
    Last edited by jkskates; 10-31-2012 at 09:25 PM.

  2. #2
    Registered User
    Join Date
    10-31-2012
    Location
    K.S.A
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: How to add points when the answer is correct?

    hi
    hopefully that's what you're looking for
    check attached file
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,643

    Re: How to add points when the answer is correct?

    I used named ranges and offsets in the formula below to make copy and pasting to the remaining columns easier.
    =IF(AND(OFFSET(H3,0,-1)<>"",OFFSET(H3,0,-1)=WinnerList),PointVals,0)
    Copy the entire points awarded column then paste to remaining PA columns
    Attached Files Attached Files
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    10-22-2012
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to add points when the answer is correct?

    Worked! Thanks so much for help!

+ 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