MHB Excel Question (asking for a friend)

[MarkFL]

Hello All! (Wave)

A friend on another site reached out to me with a question regarding using Excel. I told him I know nothing about it, but that I could probably find someone who does. Here is his question:

Here's the sheet (fantasy basketball nerding with my buddy, we make a killing every year- this is not at all private so don't worry about that):

So 26B and 26C are what we've personally paid thus far. This information is individually recorded the columns D (the price) and E (the payer) already. I'm positive there's a formula I could plug into cell 26B that would display the sum of all the values in column D that corresponded to "LS" in E, and one I could plug into cell 27B that would display the sum of all the values in column D that corresponded to "JB" in E. You see what I'm getting at? I just don't know how.

Feel free to enjoy the inanity of our team names, which we come up by sending each other random pics we'll use as team logos. We often make team names subtly (or not) indicating that we're the super fan of a particular team (and we're not), just so other owners think we'll have a thing for that team's players.

Full scale psychological warfare, Mark, last year we won like 6k (on top getting our investment back).

Thanks for any help! :D

 

[GJA]

Hi MarkFL,

This can be done using Excel's built-in SUMIF function. I was going to type something more detailed out, but I think the link below is pretty good. The one thing worth noting is that the "IF" condition of the function can include character strings to check against.

Here is a link to its description with an example that your friend can apply to his situation. https://www.ablebits.com/office-addins-blog/2014/11/04/excel-sumif-function-formula-examples/

Hope this helps!

 

[MarkFL]

Hi MarkFL,

This can be done using Excel's built-in SUMIF function. I was going to type something more detailed out, but I think the link below is pretty good. The one thing worth noting is that the "IF" condition of the function can include character strings to check against.

Here is a link to its description with an example that your friend can apply to his situation. https://www.ablebits.com/office-addins-blog/2014/11/04/excel-sumif-function-formula-examples/

Hope this helps!

Thank you very much! My friend said that "worked like a charm." (Yes)