Facebook Page
Twitter
RSS
+ Reply to Thread
Results 1 to 3 of 3
  1. Pessimist Singularitarian
    MHB Coder
    MHB Math Helper
    MHB Ambassador
    MarkFL's Avatar
    Status
    Offline
    Join Date
    Feb 2012
    Location
    St. Augustine, FL.
    Posts
    13,311
    Thanks
    34,279 times
    Thanked
    31,688 times
    Thank/Post
    2.381
    Trophies
    25 Highscores
    Awards
    MHB Chat Room Award (2017)  

MHB Calculus Award (2017)  

MHB Pre-University Math Award (2017)  

MHB Statistics Award (2016)  

MHB Calculus Award (2016)
    #1
    Hello All!

    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:

    Quote Quote:
    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!

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many
     

  3. MHB Craftsman
    MHB Math Scholar

    Status
    Offline
    Join Date
    Jan 2013
    Posts
    227
    Thanks
    130 times
    Thanked
    318 times
    Thank/Post
    1.401
    #2
    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.

    Hope this helps!

  4. Pessimist Singularitarian
    MHB Coder
    MHB Math Helper
    MHB Ambassador
    MarkFL's Avatar
    Status
    Offline
    Join Date
    Feb 2012
    Location
    St. Augustine, FL.
    Posts
    13,311
    Thanks
    34,279 times
    Thanked
    31,688 times
    Thank/Post
    2.381
    Trophies
    25 Highscores
    Awards
    MHB Chat Room Award (2017)  

MHB Calculus Award (2017)  

MHB Pre-University Math Award (2017)  

MHB Statistics Award (2016)  

MHB Calculus Award (2016)
    #3 Thread Author
    Quote Originally Posted by GJA View Post
    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.

    Hope this helps!
    Thank you very much! My friend said that "worked like a charm."

Similar Threads

  1. Cost of a gift for a friend
    By Johnx in forum Pre-Algebra and Algebra
    Replies: 3
    Last Post: September 16th, 2018, 07:35
  2. How to use the RATE function in Excel ?
    By indigo in forum Business Mathematics
    Replies: 3
    Last Post: June 8th, 2018, 18:41
  3. Excel tables
    By GerryZ in forum LaTeX Help and Discussion
    Replies: 11
    Last Post: August 26th, 2016, 09:57
  4. I need help with Excel
    By Alelin in forum Pre-Algebra and Algebra
    Replies: 2
    Last Post: May 29th, 2013, 21:50
  5. Sigma Sums In Excel
    By alane1994 in forum Calculus
    Replies: 1
    Last Post: October 24th, 2012, 14:25

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Math Help Boards