total "E" after looking at names in A and B

[mrxwantobe]

Hey all

I have a sheet with a first name in "A", a last name in "B" and monies paid in "E". Can someone help me put a total in say "G". some of the names reoccur in A and B and some are only there once but either way I need a total. It has to look in A and B because I might have a John Jones and a Phil Jones. Thanks everyone.

 

[barry houdini]

Try SUMIFS, e.g. if you want a total for John Jones

=SUMIFS(E:E,A:A,"John",B:B,"Jones")

You can do the same with the name in cells, so if you have John in H2 and Jones in J2

=SUMIFS(E:E,A:A,H2,B:B,J2)

 

[mrxwantobe]

Barry

I did a lousy job explaining what I need. Can you tell me how to upload a sample f my workbook?