Lookup a data set with multiple lines but return total value

[snash]

Hi there,
If I have a data set that contains customer names and product purchased with their price.
How can a do a lookup of that customer with the total amount purchased?

thanks

 

[StevenE06]

=SUMIF("Range with customer names", "Customer name or cell with customer name in it", "Range to sum")

 

[snash]

Brilliant - thank you

 

[snash]

What about if I have multiple lines and want to return the lines separately. As above, return each line item for Bob?

 

[NickFru]

Hello - you can use the FILTER function to extract all lines relating to Bob. Just create a data validation for the list of names and then enter the following formula;
=FILTER(Range (Excluding Headers), Then Highlight Name Range = Bob (On data validation drop down). This will extract all records for Bob only and should look like;

Name

Product

Amount

Bob	Snickers	1​
Bob	Pear	2.5​
Bob	Orange	1​

As an alternative to SUMIF,you can enter SUM(FILTER(Range (Excluding Headers), Then Highlight Name Range = Bob (On data validation drop down) which will also give you the total for Bob.