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

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

=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

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