What formula would sum up the points of each name in column C and put the answer in F2

Question

I'm trying to see the sum of each players points when they played in a GW. Is there a formula that would do this for me.

Answer 1

Hi @William Auld,

Three alternative formulas which are dynamic formulas, so these formulas are applied only once and do not need to be dragged down.

In cell F2 you can apply one of the following two formulas:

=BYROW(E2:E22, LAMBDA(a, SUMIF(B2:B22, a, C2:C22)))

=BYROW((E2:E22 = TOROW(B2:B22)) * TOROW(C2:C22), SUM)

Also if you want you can apply this formula:

=GROUPBY(B1:B22, C1:C22, SUM, 3, 1)

This formula gives results only for the unique names of the Players that you have given in column B. I have applied this formula in cell H1.

HTH

IlirU

Answer 2

Use SUMIF with the player name in column E as the criterion.

In F2 enter:

=SUMIF($B:$B, E2, $C:$C)

Then fill the formula down column F.

Explanation:

• $B:$B is the range containing player names.
• E2 is the player whose total points are being calculated.
• $C:$C is the range containing the points to sum.

This will return, in F2 and downwards, the total points for each player listed in column E.

---

References:

• Use the SUM function to sum numbers in a range
• Create a formula by using a function
• Use Excel as your calculator in Excel for Mac