Is there a formula I can use to count how many points someone has received?

Chelsea.Little

We are using smartsheet for submissions for a point-based program we are running. When someone submits an item to the smartsheet through a form, they are awarded between 1-6 points based on what the item is that they submitted. Is there a formula I can use to count how many points someone has received so far, based on the email address they submit?

For example, Julia has 15 points so far. Is there a formula I can use that will total how many points Julia has?

Paul Newcome

Take a look at the SUMIFS function:

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

.

dojones

Use this formula:

=SUMIF(UserID:UserID, UserID@row, Points:Points)

dojones

Clarification to match your sheet fields:

Add a column for Points, then

=SUMIF([Work Email]:[Work Email], [Work Email]@row, [CPC Point(s)]:[CPC Point(s)])