spittingfire
09-11-2015, 08:31 AM
Hi All,
I have the attached test data and I am trying to achieve the results in column D.
I have the already grouped by Emp_ID (column A) and what I want to do is to have a formula written that will look at the Emp_ID in column A and if the IDs are the same, total up the corresponding totals in column B and put the resulting Sum into column D.
I have manually entered a few results in column D to show what I am looking for and how I want the data in the column to be presented.
Thanks in advance for all your help.
I have the attached test data and I am trying to achieve the results in column D.
I have the already grouped by Emp_ID (column A) and what I want to do is to have a formula written that will look at the Emp_ID in column A and if the IDs are the same, total up the corresponding totals in column B and put the resulting Sum into column D.
I have manually entered a few results in column D to show what I am looking for and how I want the data in the column to be presented.
Thanks in advance for all your help.