0

I am making a simple excel sheet to keep track of soccer team players scores and saves for the season as in picture. All I need to do is to get the sum of Goals, saves and assists for each players. Played around with SUMIF and SUMPRODUCT, but wasn't able to solve this seemingly small issue.

All I need is the sum of values under corresponding header for each player. To see total goals by a person for all games, total saves for all games etc. I tried commands with logic, if value in Row 2 is 'Goals' then add that to next value under 'Goals text'. Same for Assist etc.

edit: sorry guys pasting the info code generator doesn!t work due to length or I am not tech savvy to make it.

enter image description here

Máté Juhász
  • 22,071
James
  • 3

2 Answers2

0

You can use SUMIF:

=SUMIF($D$2:$L$2,"goals",$D3:$L3) for goals, and
=SUMIF($D$2:$L$2,"saves",$D3:$L3) for saves

enter image description here

Máté Juhász
  • 22,071
0

I would like to suggest SUMPRODUCT to get Total Goal & Save by each player.

enter image description here

How it works:

  • Formula to get Total Goal in Cell B168: =SUMPRODUCT(($A$161:$A$164=A168)*($B$161:$D$164))

  • Formula to get Total Save in Cell C168: =SUMPRODUCT(($A$161:$A$164=A168)*($F$161:$H$164))

Fill both the Formulas down.

  • Same Formula can be used to get Total Kick & Assist also.
  • Adjust Data Structure & cell references as needed.
Rajesh Sinha
  • 9,403