+ Reply to Thread
Results 1 to 5 of 5

Counting occurences where dollar amount exceeds zero based on employee name

  1. #1
    Registered User
    Join Date
    08-25-2012
    Location
    Atlanta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Counting occurences where dollar amount exceeds zero based on employee name

    This seems like it should be very simple but I have stared at the computer for 2 days trying to make it work and have gotten nowhere. Tried several modifications of examples out of the forum with no luck. Here is the arrangement

    Column B - Contains multiple occurences of employees names - this info is collected from a database of project data so the column length will vary from 1 to infinity

    Column T - Contains a dollar amount based on employees names from column B's contribution to a given project

    On a 2nd sheet I have all of the employees names from the first sheet consolidated into a single list in column A.

    All that I need is to count the number of occurences in column T where the value exceeds zero based on the employees name in column B. This number will be placed on the 2nd sheet where the employees name in column A matches the employees name from column B in the first sheet.

    For example:

    I have used SUMIF to total the occurences as shown below. But there doesn't seem to be an easy way to count the values that make up the total returned by the SUMIF formula

    =SUMIF('Employee Incentive Data'!B:B,A4,'Employee Incentive Data'!T:T)

    Your assistance is greatly appreciated

    Thank you

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Counting occurences where dollar amount exceeds zero based on employee name

    Pigmul,

    Try

    Please Login or Register  to view this content.
    somewhere in Column B on your second sheet, ideally in B4, and copy down - that should do the trick.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Registered User
    Join Date
    08-25-2012
    Location
    Atlanta
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Counting occurences where dollar amount exceeds zero based on employee name

    Worked like a charm!! Thank you so much!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Counting occurences where dollar amount exceeds zero based on employee name

    if sumif() worked, you could probably have used countif() as well
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Counting occurences where dollar amount exceeds zero based on employee name

    Quote Originally Posted by Pigmul View Post
    Worked like a charm!! Thank you so much!
    Pigmul,


    Glad to help. If you're happy that this problem has been solved - as you appear to be - could be please mark the thread "SOLVED", thanks.

+ Reply to Thread

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