creating a formula with any type of loop

[union]

Hello,

I wanted to create a loop of any kind to the following. suppose I have two columns: A & B. What I would like to do is in Column A, if the name "john" appears i would like it to help me write a simple addition formula. for example, if the name "john" is located in cells a1,a3,a5,a6,a8 and a10, how would i be able to utilize a loop and create the formula "=B1+B3+B5+B6+B8+B10"?

Thanks.arithmetic loop.xlsx

[mikerickson]

How about no loop and the formula =SUMIF(A:A,"john",B:B)

[union]

Thank you very much for the quick reply. I would, but because a sheet that I have created has a ton of moving parts, it's not efficient to use a sumif. This was the best solution that I could think of.