Need help on a formula that adds the totals for individual names?

ovelzone

Hi, I wanted to create a table (similar to the example below) that adds total scores for individual names in new columns. Just wondering if it is possible? If so, what formula can I use? much appreciate if someone could please help. 

Andrée Starå

Hi @ovelzone

I hope you're well and safe!

Have you explored using a Report instead?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

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!

Amber Eakin

Hello @ovelzone - Give this a try.

=SUMIF(Name:Name, Names@row, Scores:Scores)

I hope that helps!

Andrée Starå

Hi @ovelzone

I hope you're well and safe!

Have you explored using a Report instead?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

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!

Amber Eakin

Hello @ovelzone - Give this a try.

=SUMIF(Name:Name, Names@row, Scores:Scores)

I hope that helps!

ovelzone

Hi @Amber Eakin that's brilliant.. it worked exactly how i wanted. Thank you so much for your help! Have a good weekend.

ovelzone

Hi @Andrée Starå never crossed my mind to use Report instead. The formula by @Amber Eakin did worked for my purpose. Thanks for your advise. Hope you have a good weekend!

Andrée Starå

@ovelzone

Excellent!

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!