+ Reply to Thread
Results 1 to 4 of 4

Create a formula to add cells in one column if it meets the criteria for another column

  1. #1
    Forum Contributor
    Join Date
    06-19-2012
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    143

    Create a formula to add cells in one column if it meets the criteria for another column

    I need help creating a formula in column AM to add up all the hours in column T for each individual employee listed in column R.
    Then if the sum is greater than 8, the hours entered in to the cell in column T needs to be divided by the total hours worked that day by that employee, otherwise the value in the cell (=IF(sum(employee's daily total hours)>8,T7/sum(employee's daily total hours)*8,T7).

    Please view the file in post #4 of this thread, this one has been updated.
    Attached Files Attached Files
    Last edited by Tamarissa; 07-23-2012 at 03:38 PM. Reason: Void Attached File

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Create a formula to add cells in one column if it meets the criteria for another colum

    Hello Tamarissa,

    I see you already have a formula in column AM, isn't that doing what you need? Can you indicate what values you expect to get in AM7:AM10 for example?
    Audere est facere

  3. #3
    Forum Contributor
    Join Date
    06-19-2012
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    143

    Re: Create a formula to add cells in one column if it meets the criteria for another colum

    The formula that I currently have in AM uses the total of column T (row 37), not total of the specific employee's hours (this is how it is currently being entered, one employee per tab, very time consuming & inefficient!!).

    If it is correctly adding the information for John Smith only, the value for AM7=2, AM11=2.67, AM15=1.33 & AM19=2. The rest of his values in column AM=0.

  4. #4
    Forum Contributor
    Join Date
    06-19-2012
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    143

    Re: Create a formula to add cells in one column if it meets the criteria for another colum

    And I just realized that my sum at the bottom wasn't adding in all of the hours, sorry. Here's the updated copy. Sorry
    Attached Files Attached Files

+ Reply to Thread

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