+ Reply to Thread
Results 1 to 3 of 3

SUM Rows In One Column Based On Matching Data In Another Column

  1. #1
    Registered User
    Join Date
    03-21-2023
    Location
    Liverpool, England
    MS-Off Ver
    Office 365
    Posts
    2

    SUM Rows In One Column Based On Matching Data In Another Column

    Hello, I'm trying to work out how to do something that probably has a really simple solution.

    I'm trying to SUM the results for a given person's name in the sheet.

    I.e. count up all the points for Shaun, all the points for Dan, all the points for Kate as shown below.

    There are around 500 people to count up points for though each month so ideally I could spit something out with both the name and the corresponding points rather than needing to type each name then a corresponding formula.

    Excel Screenshot.png
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: SUM Rows In One Column Based On Matching Data In Another Column

    try in E1 dragged down... =SUMIF($A$1:$A$8,D1,$B$1:$B$8), just adjust the range.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    03-21-2023
    Location
    Liverpool, England
    MS-Off Ver
    Office 365
    Posts
    2

    Re: SUM Rows In One Column Based On Matching Data In Another Column

    That's perfect! Thanks so much.

+ 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] Sorting Rows From 1 Set of Columns, Based on Matching Values in Another Column
    By jpevonap in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-04-2019, 01:05 PM
  2. Auto-adjust # of rows in a column that have a formula based on adjacent column data?
    By Norcal1 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 05-31-2018, 02:03 PM
  3. Replies: 2
    Last Post: 04-11-2014, 12:18 PM
  4. Combining Rows Based On Matching Values in one column
    By jeffocasm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2013, 07:16 PM
  5. Concatenate a column based on a column with matching rows
    By excelsior51 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2013, 11:13 AM
  6. Move Rows of Data from a Specific Column (Based on Matching Criteria) to a new Sheet
    By jordan1214 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2013, 02:30 AM
  7. Deleting Rows based on matching values in column A, in two different worksheets
    By Insert Name in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-11-2013, 08:39 PM

Tags for this Thread

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