Creating a calculated field for summing up the values

Question

What I have?:

 ----------------------------------------------
    ID  Name            Value                    |
    ---------------------------------------------|          
    1   Bob             4                        |
    2   Mary            3                        |
    3   Bob             5                        |
    4   Jane            3                        |
    5   Jane            1                        |
    ----------------------------------------------
 

What I want?

Is there any ways to do out a calculated field where if the name is "Bob" , it'll sum up all the values that have the name "Bob"?

Answer 1

Well you can use this in your calculated field

If Name = “Bob” then Value end