Help with a basic function

**Rhuumz** · 02-19-2013, 05:59 PM

Hey Guys,

I haven't had to use excel for work in over a year nearly now and man my function skills are so rusty...

I am having a problem with the syntax of a function that I think is fairly straightforward but I can't seem to dig deep and find the answer..

What I need in plain english is this....

IF the values in the "C" column = Jimmy THEN add the value in "D" column that matches the same "C" column.

I have something that looks like this....

Jimmy 3
James 1
Jimmy 1
Bob 2
Bob 3
Jimmy 1

And I just want to sort the amounts by name...

Any help is much appreciated

**ConneXionLost** · 02-19-2013, 06:23 PM

Try this:

Please Login or Register  to view this content.

**Rhuumz** · 02-19-2013, 06:36 PM

Legend!

Worked like a charm

**arlu1201** · 02-20-2013, 02:05 AM

Rhuumz,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.