Add points for entries with same name?

Mr Keith G

Trying to create a formula that will add points for all entries with the same name. Lines with dots below. I can get everything sorted on a report, but need to add up points for each person. Can't figure this part out. Any help is much appreciated!

Andrée Starå

Hi @Mr Keith G

I hope you're well and safe!

Try something like this.

=SUMIF([Team Member]:[Team Member], "Andrée Starå", Points:Points)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Mr Keith G

I hope you're well and safe!

Try something like this.

=SUMIF([Team Member]:[Team Member], "Andrée Starå", Points:Points)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Mr Keith G

It doesn't seem to be adding the points. I wonder if I have to add the name in the brackets?

Mr Keith G

I figured it out. It works, but only if I manually enter the point total. My Point column is a formula depending on Call Off Type.