Results 1 to 9 of 9

SumIf with multiple criteria

Threaded View

ndbwhunter SumIf with multiple criteria 05-16-2013, 09:54 AM
zbor Re: Need HELP with an... 05-16-2013, 10:01 AM
mikeTRON Re: Need HELP with an... 05-16-2013, 10:17 AM
ndbwhunter Re: Need HELP with an... 05-16-2013, 10:23 AM
ndbwhunter Re: SumIf with multiple... 05-16-2013, 10:35 AM
ndbwhunter Re: SumIf with multiple... 05-16-2013, 12:36 PM
ndbwhunter Re: SumIf with multiple... 05-17-2013, 08:54 AM
Pepe Le Mokko Re: SumIf with multiple... 05-17-2013, 09:01 AM
nathansav Re: SumIf with multiple... 05-17-2013, 09:04 AM
  1. #1
    Registered User
    Join Date
    05-16-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    9

    SumIf with multiple criteria

    Here is the breakdown of the spreadsheet that I am working on.

    Column A = account number

    Column B = name

    Column C = employee ID

    Column D = doesn't matter

    Column E = $ amount

    This spreadsheet has approximately 37,000 lines. In column B, some names are repeated multiple times. Basically, what I need is a formula that will sum the figures in column E, if the names in column B are the same and one of the employee ID's in column C is equal to "8805", and tell me what percent of the total was in 8805.

    For example:

    John is listed three times with three different ID numbers, one of which is 8805. I need to know the sum of all three wages and what percentage of the total were paid to 8805.

    (remember that not all names are repeated. Some are in there once, and others may be repeated ten times)

    I hope I'm making some sense and not just rambling on. Can anyone help with this?
    Last edited by ndbwhunter; 05-16-2013 at 10:23 AM. Reason: moderator requested new title

Thread Information

Users Browsing this Thread

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

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