Calculate tally based off duplicate values in another column

[joeccc]

<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".

Thanks

Last name	First name	Email	ID	Correct/Incorrect	Correct Validation	Raw	Percent	Scored/Unscored Attribute	Score Point	Calculated Raw Score
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Unscored	0
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Incorrect	incorrect	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Smith	John	smith.john@email.com	10000	Correct	correct	60	67	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Unscored	0
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Incorrect	incorrect	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Hand	Christopher	hand.chris@email.com	10001	Correct	correct	79	88	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Unscored	0
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Incorrect	incorrect	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1
Mund	Benjamin	mund.benjamin@email.com	10002	Correct	correct	65	72	Scored	1

<tbody>
</tbody>

 

[Eric W]

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)

 

[BruceJ]

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.

 

[joeccc]

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

 

[Eric W]

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.

 

[joeccc]

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)

Thanks Eric! Your solution works! Cheers.