+ Reply to Thread
Results 1 to 5 of 5

Help needed in summing up amounts against repeating names

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Help needed in summing up amounts against repeating names

    Respected experts I have a sheet where against some voucher numbers I typed name of employee who have entered it wrongly and then I put a fine amount against this .And you know that names may repeat again and again for different vouchers .then I have another section of the sheet where I have names of all the employees and now I want excel to sum only the amount of fine for each employees who have committed mistakes.can anyone help me in this regard .problem is that I the names are actually got from a reference because employee can be changed.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help needed in summing up amounts against repeating names

    Have you tried the SUMIF() function yet?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Help needed in summing up amounts against repeating names

    Have you tried SUMIF?

    =SUMIF(Name_range, Name_cell,Fine_Range)
    Quang PT

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Help needed in summing up amounts against repeating names

    Richard I have tried this: =SUMIF($D$2:$D$15,"employee name",$E$2:$E$15) and it worked. but instead of "employee name" I need to use the cell refference.Can you please guide me in this matter?

  5. #5
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Help needed in summing up amounts against repeating names

    Quote Originally Posted by bebo021999 View Post
    Have you tried SUMIF?

    =SUMIF(Name_range, Name_cell,Fine_Range)
    Bebo0021999,,,it worked.Thanks actually I was putting inverted commas around the cell refference like employee name.
    Thank you and also Mr. Richard

+ 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. Replies: 4
    Last Post: 11-23-2010, 07:10 PM
  2. Summing Amounts from Multiple Rows
    By Valmanway in forum Excel General
    Replies: 5
    Last Post: 06-25-2009, 04:34 AM
  3. Summing Amounts in Data
    By Kleinstein in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-05-2009, 09:02 AM
  4. [SOLVED] Conditional summing with large amounts of data
    By Revontulet in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2005, 05:06 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