Results 1 to 3 of 3

Sum cells that meet criteria in adjacent column

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2008, Mac
    Posts
    9

    Sum cells that meet criteria in adjacent column

    Hi, excel novice here. I need to sum some numbers in a column, but only sum only those that match a given name in an adjacent column.

    The issue is that I have a list of people with corresponding number amounts, and I need to total these amounts for each person. Since the list of people is extremely long, I would like to just be able to copy a simple formula into each cell of a new column that will sum all the numbers which have matching names in the adjacent column.See attached screen cap.

    Thanks!!
    Attached Images Attached Images
    Last edited by conorsgaffney; 09-13-2010 at 11:02 AM.

Thread Information

Users Browsing this Thread

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

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