# 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:

Screenshot 2020-04-19 13.56.10.png

SUMIF might be more useful

Try this. I hope you enjoy this tool

Another great solution. Thank you

Hello,

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.

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.