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

1. ## 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.

2. ## 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?

3. ## 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. ## 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

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

#### 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