Filter data using vlookup

I am trying to create a way to easily filter data and display totals for specific customers. I think this can be accomplished using VLOOKUP but I am stuck.

Can somebody assist me to show me how I can display the total amount for Customer 1, Customer 2, and Customer 3 in their own cells? Example below:

Thanks in advance!

Screenshot 2020-04-19 13.56.10.png

SUMIF might be more useful

Try this. I hope you enjoy this tool

Pivot Table

Another great solution. Thank you :slight_smile:


check / study the following formula based solution (which looks a bit too complicated due your usage of the phrase TOTAL in conjunction with the Customer Name in the same cell).

Sample file [Updated]: SUMByCustomer.ods

Hope that helps.

If the answer helped to solve your problem, please click the check mark (:heavy_check_mark:) next to the answer.

Thank you! This works great.

However, it seems that there was a slight issue with the formula because the range $B$1:$B$10 was off

=SUMIF($A$2:$A$10,REGEX(A12," TOTAL",""),$B$1:$B$10)

But the value here does work:

=SUMIF($A$2:$A$10,REGEX(A12," TOTAL",""),$B$2:$B$10)

Thanks again. I really appreciate the help!

Sorry for the typo - updated sample file.