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
|