SUM IF Name and Points

CieraB

I need to calculate the total number of points in the "Points Column" by each person in the "Name" column and I cannot figure out how its calculated. I tried to brainstorm with another co-worker and we both had trouble trying to figure this one out. Please advise.

Stefan

Hello Ciera,

what you need is the formula COUNTIF.

https://help.smartsheet.com/function/countif

In your case:

=SUMIF(Name:Name, ="Ciera Broberg", [Points Earned:Points Earned]:[Points Earned:Points Earned])

Hope this helps

Stefan

Andrée Starå

Hi @CieraB

To add to Stefan’s excellent advice.

You can change the Name to Name@row if the Name is in the same row, so you don’t need to worry about the specific name.

Also, I think Stefan added the Points Earned an extra time by mistake.

Try this.

=SUMIF(Name:Name, Name@row, [Points Earned]:[Points Earned])

Did that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Stefan

Hello Ciera,

what you need is the formula COUNTIF.

https://help.smartsheet.com/function/countif

In your case:

=SUMIF(Name:Name, ="Ciera Broberg", [Points Earned:Points Earned]:[Points Earned:Points Earned])

Hope this helps

Stefan

Andrée Starå

Hi @CieraB

To add to Stefan’s excellent advice.

You can change the Name to Name@row if the Name is in the same row, so you don’t need to worry about the specific name.

Also, I think Stefan added the Points Earned an extra time by mistake.

Try this.

=SUMIF(Name:Name, Name@row, [Points Earned]:[Points Earned])

Did that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!