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.
<tbody>
</tbody>
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?
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.
| Jim | 1 |
| Brian | 2 |
| Jim | 3 |
| Brian | 4 |
| Josh | 5 |
<tbody>
</tbody>
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?
