+ Reply to Thread
Results 1 to 2 of 2

Count cells in a row depending on value in different row, corresponding column

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    Kansas City, MO
    MS-Off Ver
    Excel 2007
    Posts
    1

    Count cells in a row depending on value in different row, corresponding column

    I have a spreadsheet containing student responses to an ACT practice test. For the English section, there are 75 items in 75 columns. Each row corresponds to a student. I have figured out formulas to convert a,b,c, and d to 1's and 0's for correct and incorrect, and count the number correct. I created an array and use vlookup to convert to a scale score.

    My next task is to count the number of correct responses that apply to each subscore. There are 40 items in "Usage/Mechanics" (UM), and 35 in "Rhetorical Skills" (RH).

    I inserted a row in my scoring table with a "1" in the column of each UM item, and a "2" for each RH. I want to count all correct responses in each row if the value of row 2 in the same column is a "1" and use that to calculate the UM sub-score. Then I will do the same for RH.

    I have been playing around with COUNTIF, SUMIF, and VLOOKUP, but I don't know how to communicate to excel exactly what I am trying to do. Thanks in advance for any guidance.
    Attached Files Attached Files
    Last edited by Shimshon; 10-28-2011 at 01:48 PM. Reason: Added Attachment

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Count cells in a row depending on value in different row, corresponding column

    The explanation doesn't really give enough detail in the absence of the workbook. I suggest attaching your workbook, after you remove the student names.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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