=SUMPRODUCT(--(LEFT(A1:A3)="C")*(B1:B3))

"HERNAN" wrote:

I want to know how much money any person that start with the letter "C"
collected

For example

Name Collect

Carl $10
Alan $10
Cynthia $20

Total C = $30


How do I create the formula that gives me Total C = $30

Thank you