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!
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.
If the answer helped to solve your problem, please click the 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.
