TWO VARIABLES - ONE RESULT

H

HERNAN

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
 
M

Marcelo

hi Herman

try to use sumproduct

=sumproduct(--(left(a2:a1000,1)="c"),b2:b1000)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"HERNAN" escreveu:
 
H

HERNAN

it works really well, thank you!!
Now I have another question, using the same example, how do I copy and paste
automatically into another sheet all these rows.
 
Top