Calculating all numbers by name.

[Newbienew]

I am currently looking for a formula that i can sum up the all the numbers under one persons name. So if John name on he work sheet 5 times need to calculate all the numbers that john has. I have attached a sheet to make it more understandable a bit.

https://www.dropbox.com/s/egwvb6h0urumbvc/example.xlsx?dl=0

 

[Fluff]

Have a look at the SUMIF function. https://exceljet.net/excel-functions/excel-sumif-function