Excel help

[Baconator]

I am trying to compile some data and am wondering if someone can help me.

I have employees in one column and the % of full time they work in another column. Employees that are shared will have 60% in one column and 40% in another.
I'm trying to make excel see if two names are identical to add together the "shared" % to equal 100%.
Can anyone help?

[thedonger]

You could do a subtotal by name. Should do the trick.

[Baconator]

You could do a subtotal by name. Should do the trick.

Can you tell me the function?

[jimmyeatsworld]

If function should work.

You can also do a vlookup.

Google those two. Should provide examples.

[JamesY]

Assuming you have columns A (employee), B (% FT), C (% PT) and , D (shared), you can put the following formula for column D:
if(countif($A$1:$A$1000,A1)>1,100%,"")

[Baconator]

Assuming you have columns A (employee), B (% FT), C (% PT) and , D (shared), you can put the following formula for column D:
if(countif($A$1:$A$1000,A1)>1,100%,"")

The columns are a (employee name) and b (% of full time) so in the list of % of full time they work. So there are some employees that work in two different departments so they show up as Jon doe 30% and then the next line Jon doe 70%. I want excel to look and see if the names are exactly the same that it would add those percentages together. Other people work in multiple departments but don't add up to full time.

Does that make sense?

[EvolutionGSR]

Sounds like you want to pivot table the data. You will have a data sheet, and a sheet to display the data you want. That is if I am understanding what you want correctly.

[JamesY]

The columns are a (employee name) and b (% of full time) so in the list of % of full time they work. So there are some employees that work in two different departments so they show up as Jon doe 30% and then the next line Jon doe 70%. I want excel to look and see if the names are exactly the same that it would add those percentages together. Other people work in multiple departments but don't add up to full time.

Does that make sense?

In a new column (C), use sumif () function. =sumif ($a$2:$a$1000, a1, $b$2:$b$1000)

[Baconator]

In a new column (C), use sumif () function. =sumif ($a$2:$a$1000, a1, $b$2:$b$1000)

Awesome. That worked. Thank you

[AGGRO]

Or simply sort the table, group by or pivot it by name. Sum totals.