Macro help - adding totals by name that may occur multiple times

[rubatoguy]

I have a spreadsheet that is sorted in name order that lists name, code and and amount.
The name may appear multiple times, usually either 1, 2 or 3 times. Currentyl I am adding the amount manually, and I was thinking there must be a way to create a macro to do this. So, my worksheet looks like so:

NAME CODE MINUTES
SMITH, SAM E F 100
SMITH, SAM E F 200
SMITH, SAM E S 360
TAYLOR, JANE Z F 100
ZACK, WILL T S 120
ZACK, WILL T S 120
ZIPPER, GEORGE F 240
ZIPPER, GEORGE F 120
ZIPPER, GEORGE F 120

I want to end up with:
SMITH, SAM E F 300
SMITH, SAM E S 360
TAYLOR, JANE Z F 100
ZACK, WILL T S 240
ZIPPER, GEORGE F 480

The key is to add the numbers when the name and code match, and end up with a single row with the total.
Is there a way to do this in a macro?

Thanks,
Todd
A Macro neophyte.

 

[JLGWhiz]

You can do that with a SUMIFS() function if you have a list of the names. This example only uses 100 rows.

=SUMIFS(C1:C100, A1:A100, "Smith, Sam E",B1:B100, "F")
=SUMIFS(C1:C100, A1:A100, "Smith, Sam E",B1:B100, "S")

You would need two formulas for each name. However, if you have more codes than F and S then VBA would probably be a better solution.