Using the "Begins with" filter in a sum(if)) construction

To filter my data, I often use the "Begins with" filter excel provides.

Is there a possibility to incorporate this function into a sum if
construction?

So logically I would like this

if CELL begins with TEXT then sum OTHERCELL

example

FrankD home 10
FrankV home 20
FrankD business 30
FrankD business 40

Normally I would then filter, and choose "Begins with FrankD" to have all
FrankD's (totalling 80 (10+30+40)), and then put in the result manually in
the desired field.

But I would like to make a formula in that desired field that does this
automatically.

Is this possible?

(I could do it with a combined if, stating "if CELL >Frank AND CELL<FrankV",
that would give me the correct result too, but is very cumbersome when in my
case I would have a 20-layer if)

thnx!

Wouter

=SUMIF(A:A,"FrankD*",B:B)

HTH
Jason
Atlanta, GA

>-----Original Message-----
>To filter my data, I often use the "Begins with" filter
excel provides.
>
>Is there a possibility to incorporate this function into
a sum if
>construction?
>
>So logically I would like this
>
>if CELL begins with TEXT then sum OTHERCELL
>
>example
>
>FrankD home 10
>FrankV home 20
>FrankD business 30
>FrankD business 40
>
>Normally I would then filter, and choose "Begins with
FrankD" to have all
>FrankD's (totalling 80 (10+30+40)), and then put in the
result manually in
>the desired field.
>
>But I would like to make a formula in that desired field
that does this
>automatically.
>
>Is this possible?
>
>(I could do it with a combined if, stating "if CELL
>Frank AND CELL<FrankV",
>that would give me the correct result too, but is very
cumbersome when in my
>case I would have a 20-layer if)
>
>thnx!
>
>Wouter
>
>
>.
>