If cells in column "B" contain the same text (name), then add together corresponding values in the rows located in column "L"

[cweaver]

I'm working on trying to add together invoice balances to create a TOTAL balance for each customer who hasn't paid their bills. So...

If cells in column "B" (customer name) contain the same text (same customer name), then add together corresponding values in the rows located in column "L"

P.S. I have 3,000+ rows in this excel, so I need to apply a formula to quickly give me total balances for all of these customers. THANK YOU! I LLOVE MR EXCEL!

 

[cweaver]

Thank you All! Both ways work. The "Subtotal" method worked, but I like the other as well! Thanks again!

 

[etaf]

you are welcome