+ Reply to Thread
Results 1 to 6 of 6

Adding up totals based on criteria from another column

  1. #1
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    Adding up totals based on criteria from another column

    In my attached worksheet, I have a sheet with a list of players, their position, and their projected stats for the upcoming season.

    I'm trying to have the totals of Columns I:R add up in row 44 based on the position listed in column B.

    For the gold cells hitting, I would only like it to add to the totals in cells I44:M44 if one of the following positions (C,1B,2B,SS,3B,INF,CI,MI,OF,LF,CF,RF,DH,UTIL) is listed next to the players name. Also, for the blue cells pitching, I would only like it to add to the totals in cells N44:R44 if one of the following positions (SP,RP,P) is listed next to the players name.

    The positions listed in column B will always be changing depending on the amount of players for each team so I need the formula to apply all the way down to row 43 even though there are no players listed in rows 30 to 43 currently.

    Please let me know if there are any questions, thanks very much!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 2021
    Posts
    2,234

    Re: Adding up totals based on criteria from another column

    Hello,

    Try in I44 and copy to M44.

    =SUM(SUMIF($B4:$B43,{"C","1B","2B","SS","3B","INF","CI","MI","OF","LF","CF","RF","DH","UTIL"},I$4:I$43))

    N44 and copy to R44

    =SUM(SUMIF($B4:$B43,{"SP","RP","P"},N$4:N$43))
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    Re: Adding up totals based on criteria from another column

    Quote Originally Posted by Haseeb A View Post
    Hello,

    Try in I44 and copy to M44.

    =SUM(SUMIF($B4:$B43,{"C","1B","2B","SS","3B","INF","CI","MI","OF","LF","CF","RF","DH","UTIL"},I$4:I$43))

    N44 and copy to R44

    =SUM(SUMIF($B4:$B43,{"SP","RP","P"},N$4:N$43))
    100% perfect, thanks a bunch!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,308

    Re: Adding up totals based on criteria from another column

    Or this...
    =SUMPRODUCT(($B$4:$B$43={"C","1B","2B","SS","3B","INF","CI","MI","OF","LF","CF","RF","DH","UTIL"})*(I$4:I$43))

    Note you have a space (or something) in most of those cells, you need to remove that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    11-23-2013
    Location
    San Diego
    MS-Off Ver
    Excel 2013
    Posts
    457

    Re: Adding up totals based on criteria from another column

    Quote Originally Posted by FDibbins View Post
    Or this...
    =SUMPRODUCT(($B$4:$B$43={"C","1B","2B","SS","3B","INF","CI","MI","OF","LF","CF","RF","DH","UTIL"})*(I$4:I$43))

    Note you have a space (or something) in most of those cells, you need to remove that
    Thank you very much

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,308

    Re: Adding up totals based on criteria from another column

    Happy to help, thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Adding Values from One Column Based on Criteria in another column
    By andymc80 in forum Excel General
    Replies: 1
    Last Post: 01-30-2013, 09:29 AM
  2. Replies: 3
    Last Post: 01-10-2012, 10:41 PM
  3. Replies: 2
    Last Post: 09-30-2010, 06:02 AM
  4. Adding up a column based on two Criteria's in a row
    By EXCELNEWCOMER in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2008, 12:44 PM
  5. Adding up a column based on Criteria
    By halvy52 in forum Excel General
    Replies: 2
    Last Post: 07-27-2007, 06:12 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1