Foreach style loop in Excel, no VBA?

[RaGTiME]

Hi, I am working in Excel Online and am wondering if there is a good way to implement a foreach loop. I do not believe Excel Online currently supports VBA macros, but if you know how I can add them, I'd be willing to work with them.

I have two columns of data, A and B. A contains names, B contains integers. I am attempting to sum all of the integers from column B that correspond with a specific name in column A.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Jim
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Brian[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Brian[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Josh[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]

I would like to be able to write a function that would sum all of Jim's integers (returning 4). Is this possible without VBA macros?

 

[Eric W]

I don't know Excel Online, but have you tried

=SUMIF(A1:A5,"Jim",B1:B5)

 

[RaGTiME]

I don't know Excel Online, but have you tried

=SUMIF(A1:A5,"Jim",B1:B5)

Perfect, thanks a ton!