Keeping track of points against I am making a document to keep track of scores i

Question

Keeping track of points against

I am making a document to keep track of scores in a game and want to be able to have various stats pulled. One of them is points against, and I am having trouble writing the formula. I have tried Sumif and sumifs, but have been getting errors or not the number I want.

here is a sample data set:

Here is my current stat table:

Can anyone suggest a formula to keep track of points against?

Winner Ben Score Rick Score Thomas Score Thomas 25 27 Ben 22 20 Ben 21 16 Rick 16 21 Rick 16 21 Ben 21 18 Rick 21 13 Rick 26 24 Thomas 17 21 Thomas 17 21

Explanation / Answer

=SUMPRODUCT(($A$2:$A$11=I1)*($C$2:$C$11+$D$2:$D$11))

Related Questions

Navigate

• Browse (All)
• Browse K
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.