TWO VARIABLES - ONE RESULT
 

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

TWO VARIABLES - ONE RESULT
 

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:

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

TWO VARIABLES - ONE RESULT
 

=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

TWO VARIABLES - ONE RESULT
 

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.


"Marcelo" wrote:

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:

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