+ Reply to Thread
Results 1 to 3 of 3

Totaling a sum if a person appears

  1. #1
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    140

    Totaling a sum if a person appears

    Probably easy for you guys but can you help me with this formula (sample spreadsheet attached). I would like to total how much Hugh (in column D) is getting paid (column E) and put that number in Column N. I may add Hugh (or move) him to a different row in the same column (D) later. I would also like to add more people to column D and have their totals as well.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-17-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Totaling a sum if a person appears

    Try the formula below. You have to make sure that the name in M4 is exactly the same as the name in column D, so you have to change it to "Hugh W"

    HTML Code: 

  3. #3
    Forum Contributor
    Join Date
    12-10-2012
    Location
    Petalu
    MS-Off Ver
    Excel 2010
    Posts
    140

    Re: Totaling a sum if a person appears

    Thanks! I changed the C column in your formula to E and it worked. 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. Totaling a group of rows by the name of the person
    By Actos in forum Excel General
    Replies: 6
    Last Post: 04-17-2016, 03:48 PM
  2. [SOLVED] Run calculations in template for 1 person, copy-paste results, repeat for next person
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2014, 06:02 PM
  3. Count and list dates that appears per person
    By Smally in forum Excel General
    Replies: 7
    Last Post: 09-01-2014, 10:52 AM
  4. VBA to convert person-to-event into person-person
    By LuckyStrike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 02:34 PM
  5. Replies: 5
    Last Post: 08-21-2013, 12:55 PM
  6. Transpose/Pivot multiple rows per person into 1 row per person with fixed columns
    By MaestroEnrique in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2013, 06:35 AM
  7. Replies: 3
    Last Post: 02-27-2007, 05:27 AM

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