Calculate tally based off duplicate values in another column

joeccc

New Member
Joined
Jul 27, 2017
Messages
3
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>I need help with a tally for "Calculated Raw Score" of "Score Point" = "1" for each "ID". I have tried SUMIF, but I am unsure how to set the criteria to filter the "ID".:confused:

Thanks

Last nameFirst nameEmailIDCorrect/IncorrectCorrect ValidationRawPercentScored/Unscored AttributeScore PointCalculated Raw Score
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Unscored0
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Unscored0
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Unscored0
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Unscored0
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Unscored0
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Unscored0
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Unscored0
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Unscored0
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Unscored0
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Unscored0
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Incorrectincorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
SmithJohnsmith.john@email.com10000Correctcorrect6067Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Unscored0
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Unscored0
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Unscored0
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Unscored0
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Unscored0
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Unscored0
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Unscored0
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Unscored0
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Unscored0
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Unscored0
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Incorrectincorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
HandChristopherhand.chris@email.com10001Correctcorrect7988Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Unscored0
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Incorrectincorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1
MundBenjaminmund.benjamin@email.com10002Correctcorrect6572Scored1

<tbody>
</tbody>


 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Welcome to the forum.

Are you just trying to add up the score points for a given name? Try this in K2:

=SUMIF(D:D,D2,J:J)
 
Upvote 0
This will give you the total for each ID on each line for that ID.

=SUMIF($D$7:$D$14,D7,$J$7:$J$14)

=SUMIF(Range of IDs,ID,Range of Raw Scores)

You could also use the Subtotal Function under Data.
 
Upvote 0
Welcome to the forum.

Are you just trying to add up the score points for a given name? Try this in K2:

=SUMIF(D:D,D2,J:J)

Each name has 100 rows, trying to get a total for each name that = "Correct" and "scored" on one line in cell "Calculated Raw Score". Each row will have the names calculated raw score.

Thanks
 
Upvote 0
Maybe:

=COUNTIFS(E:E,"correct",I:I,"scored",D:D,D2)

or

=IF(D2<>D1,COUNTIFS(E:E,"correct",I:I,"scored",D:D,D2),"")

if you only want to see the value on the first row of a given ID.
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top