Totaling multiple values - VLOOKUP

[Gus80]

Hey everybody

Hopefully somebody can help with this problem:

I have a large list of Invoices and amounts that I need to total by customer. Is there a way to use VLOOKUP or something similar to search for a customer name and return a total of all of their invoices. I have attached a small example of the spreadsheet that I am drawing the data from.

Thanks in advance.

Mark

[daddylonglegs]

Try SUMIF

To sum all invoice amounts in column E for customer aaa in column A

=SUMIF(A$4:A$6,"aaa",E$4:E$6)

If you put customer name in a cell, e.g. Y2 put this formula in Z2

=SUMIF(A$4:A$6,Y2,E$4:E$6)

and copy down for additional customer in Y3,Y4 etc.

[Gus80]

Awesome mate -- I completely forgot about sumif -- feel mildly silly now

Thankyou very much as always

Mark