conditional summation of cells

[AdMission]

I realize this is very easy for most on this board, but my expertise is quite limited.

I would like to build a formula to add a unique normalization factor to scores that that individual has given.

[TABLE="width: 0"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Individual[/TD]
[TD]Score[/TD]
[TD]Score + NF[/TD]
[TD][/TD]
[TD][/TD]
[TD]Normalizing Factor[/TD]
[/TR]
[TR]
[TD]AM[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]AM[/TD]
[TD="align: right"]0.00540[/TD]
[/TR]
[TR]
[TD]AM[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]KB[/TD]
[TD="align: right"]-0.00221[/TD]
[/TR]
[TR]
[TD]AM[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]CT[/TD]
[TD="align: right"]-0.00400[/TD]
[/TR]
[TR]
[TD]AM[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]GV[/TD]
[TD="align: right"]-0.00185[/TD]
[/TR]
[TR]
[TD]KB[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]BW[/TD]
[TD="align: right"]0.00640[/TD]
[/TR]
[TR]
[TD]KB[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]YZ[/TD]
[TD="align: right"]0.3413[/TD]
[/TR]
[TR]
[TD]CT[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CT[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CT[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GV[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GV[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BW[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]YZ[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1049684-multi-varible-summation.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.